Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Properties=""""; This is a free simple .NET compliant MySQL driver. Project space at SourceForge. MySQL OLEDB Type: OLE DB Provider Usage: Provider=MySQLProv Manufacturer: MySQL Standard Provider=MySQLProv;Data Source=mydb;User...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 Report" Select the "Shared Data Source" you just created > Next Click on the "Query Builder" button Right-click on any empty space in the first frame > Select "Add Table..." Add and specify the query as you would with any SQL query. (to create the...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 hate sites that do not have a search feature? I do. I think it defeats the purpose of cramming information endlessly in cyberspace. So we want to give a search engine to our users. This sounds really simple, we could try: $search_term_esc =...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

List all cron jobs for all usershttps://www.joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

04 May 2011 Annoyingly necessary. tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of each line. function clean_cron_lines() { while...

• Type: Article
• Author: Joel Lipman
• Category: Linux
• Language: *

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 file uploads immediately corrupt this component. The component itself is sort of good, but file description has very little space allocated on your website and RocketTheme templates would create a style that was hard to customize. Remository Really...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

AutoHotkey Format Date and Format Secondshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 HH:mm:ss) IfInString, val, - { StringReplace, val, val, -,,All StringReplace, val, val, :,,All StringReplace, val, val, %A_Space%,,All } ; Standard European format (dd/mm/yyyy HH:mm:ss) IfInString, val, / { ThisTime:=SubStr(val, InStr(val, " ")+1)...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 Note that instead of just saying if this value equals "Name:" I've added some code to trim the values. If the user types two spaces, then we want the field to understand this as "no one entered anything", treat it as empty. this.value.split('...

• Type: Article
• Author: Joel Lipman
• Category: JavaScript
• Language: en-GB

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 Create Task... Under the General tab, for "Name" give it a general name with no symbols/special characters and preferably no spaces (I tend to give it an all lowercase name with no spaces). tick the checkbox Run with highest privileges. set "Configure...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 following: create_countriesipranges_table.sql: SQL to create a pre-populated table into a MySQL database. iana_ipv4_address_space_registry.csv: comma separated values list of all countries, regions and their respective IP ranges. ip_lookup.php: to use...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 some core files in Joomla. As a precaution, you may want to back up all your website files and its database. Or, if space is limited, you can backup the files I have listed here (the ones we will be modifying): \plugins\search\content\content.php...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 the page would end on a dataset row and continue the next page with the rest of the dataset. This footer allows for a large space at the bottom of the page indicating the page number. The footer of the dataset (in black) is the same image used in the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 will rename files which contain the string " (Copy)" and replace it with nothing (so removes it). The challenge here is the space character and delimiting by a string. The Gist -- What I have Image00001 (Copy).jpg Image00002 (Copy).jpg -- What I want...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 Defines a group of elements to be used in complex type definitions import Adds multiple schemas with different target namespace to a document include Adds multiple schemas with the same target namespace to a document key Specifies an attribute or...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: en-GB

DJI Phantom FC40 - Fun at the raceshttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 picture of whole track beforehand and plan a route). Strong Winds: Fighting the wind to keep up with the cars. Keep as much space as possible between our marshall. Not Near People: I could not risk flying low so I took a measure of about 3 people high...

• Type: Article
• Author: Joel Lipman
• Category: Quadcopters
• Language: *

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 So I needed to clear space on a workstation's C drive. There are other programs about and even some built-in to MS Windows that could potentially be used. This is a quick article on how to write an AutoHotkey program to simply return the folders in the...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 yet had the service account authorized by a G-Suite Administrator (see 2b). Scope is a string of scope urls delimited by a space (in this example only one). ISS is the client email taken from the JSON key downloaded from Google. // Build token payload...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 Link Login to ZohoCRM as the creator super admin/owner (might not be the same as CRM super admin!!!) Go to Setup » Developer Space » Connections » Create Connection » Zoho Ensure you enable/tick "ZohoCreator/creatorapi". Note the name that you call it...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 list of [1,2,3,4,5] // NB: "1mySep2mySep3mySep4mySep5".toList("mySep"); // yields list of [1,2,3,4,5] Replace any multiple spaces with a single space: v_MyString = "Hello World!"; v_FormattedString = v_MyString.replaceAll("[ ]+"," ",false); // yields...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 ERROR_invalid_operation_type Sounds rather straightforward, Login to ZohoCRM as Administrator > Setup > Developer Space > Connections > Add Connection > Give it a name and then select Scopes > and get ERROR_invalid_operation_type Solution: Remove some...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 a Zoho OAuth Connector, here's how you do it in CRM: Login to Zoho CRM as an administrator and go to Setup Under Developer Space click on "Connections" Under Pick your Service click on "Zoho OAuth" (NOT "Zoho" - there are 2 Zoho options) Give the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *