Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 under the "Search Only:" heading and then a list of components. Find the value of the checkbox by viewing the HTML source and you should see something like the following: // take the value of the checkbox (eg. doc_indexer) I have set the module by...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 - Parameter: Number of links to include images. - Parameter: Number of links to include description. - Parameter: Specify source folder for images. - Parameter: Specify image type for thumbnails. - Parameter: Specify Weblink Category - Parameter: Use...

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

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 they changed default encoding from "ISO-8859-1" to "UTF-8". So if you get null from htmlspecialchars or htmlentities..." Source: PHP Manual My fix (in some cases): $my_description = html_entity_decode(htmlentities($my_description, ENT_COMPAT,...

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

Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 a while so don't panic if you find empty folders. Doing a 'send/receive' will bring up the dialog showing its progress. Source: Windows Live Mail and Outlook Mail - Microsoft Community Server URL for hotmail setting in Windows LiveMail - Microsoft...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 false } Reminder: if you are adding the description, then pass this as a parameter to the above function. Source(s): Google Drive API v3 Google OAuth 2.0 Playground Google Developers Console - APIs RFC 2387 - The MIME Multipart/Related Content-type...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 which you will have to be careful on ensuring this is NOT passed back to the system or is retrievable by any third-party. Source(s): My *nix world - Upload file to Google Drive programmatically Google OAuth 2.0 Playground

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 Application.ActiveWorkbook.Close False Next Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub Source(s): How To Split A Workbook To Separate Excel Files In Excel

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

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 will get an error in which case you could probably add another trigger like above but with BEFORE UPDATE ON my_table_name. Source(s): Online regex tester and debugger: PHP, PCRE, Python, Golang and JavaScript StackOverflow - MySQL Insert row, on...

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

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 ) >= 0) { b_BadWordFound = true; } } // if not found if(!b_BadWordFound) { break; } } // output return v_Output; } Source(s): Zoho Creator - Community Forum - Random Sort/Shuffle a List Zoho CRM - Community Forum - Random number generator (Lead Module)...

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

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 calls/day [Maximum 1,000,000] Ultimate Edition: 15000 + (Number of User licenses x 2000) API calls/day [Maximum 2,000,000] Source(s): Zoho Books API v3 Documentation Zoho Accounts - Setup OAuth Zoho CRM API v2 Documentation

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" --profile-directory="Profile 11" "https://duckduckgo.com" Source(s): How to make Mail app open automatically upon windows start How To Create A Windows Shortcut To Open A Specific Chrome...

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

Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 used in fuzzy logic searches to broaden the resultset containKey Applies to maps only containValue Applies to maps only Source(s): Zoho Deluge - Functions which return a boolean value Community » Zoho Creator » CASE INSENSITIVE EXAMPLE PLEASE

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

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 the ORDER BY to give me the highest count first in descending order. I have added a LIMIT to only return the top 50 words. Source(s): Counting word occurrences in a table column Stack Overflow: What is the MySQL query equivalent of PHP strip_tags?

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

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

17 March 2020 You should be redirected to a page which lists the "status" as connected as well as a snippet of Deluge for the usage Source(s): Zoho CRM Developer - getFields Method - Comparison

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

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 Error: Argument type mismatch -Found 'TEXT' but Expected 'Long' // Solution: Convert your string into a date. Source(s) toTime() function | Help - Zoho Deluge unixEpoch() function | Help - Zoho Deluge

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 text files (TXT) these will only attach to the Sales Order in the CRM record but not to the Sales Order in Zoho Books.. Source(s): Zoho Books API Documentation: Add attachment to a sales order Zoho Deluge - Invoke URL

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

Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 Provisioning ms-settings:workplace-provisioning ms-settings:provisioning Windows Anywhere ms-settings:windowsanywhere Source(s): Microsoft - Launch the Windows Settings app

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 Usage ------------- v_My100NsUnits := 9858250000 v_DisplayHMS := Convert100nsToHMS( v_My100NsUnits ) ; yields 00:16:25 Source(s): Microsoft - Windows Properties - Win32 Apps AutoHotkey - Filexpro() Google - Convert 100ns to Milliseconds

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

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 created order Regular expression reminder (do not use): v_SearchName = v_SearchName.replaceAll("([&\'])","\\$1",false); Source(s) Zoho CRM - Get Records through a COQL Query Zoho CRM - Query API - An Overview

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

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 used this task which contradicts documentation: In a custom function In an Action item in Report In a schedule workflow Source(s): Zoho Creator - Insert rows in Subform (via Deluge Script)

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