Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 You then refer to it in your XML file where instead of type="sql" use type="modal_article". A usage example is: Just copy & paste the below into a PHP file and include it in your component, the solution is really that straightforward. Feel free to check...

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

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 on a website I've bookmarked (my personal site :c) My own with Typos Note that the below only prints out the SQL query to copy and paste into your SQL administration software. You can put a distinct on it (not forgetting the collate). This example is...

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

Set up Desktop SlideShow in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 your home drive (check that this is the one on the homedrive and preferably not C:\ drive). I’ve called mine “Win7_ScrSvr”. Copy a few background images into the folder. Right-click on one of the images and select “Set as Background” Right-click on the...

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

Access MySQL databases using Oracle SQL Developerhttps://www.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 MySQL (Connector/J) connector from http://www.mysql.com/products/connector/ [Optional Step] Uncompress the download, then copy or move the JAR file (at time of print: mysql-connector-java-5.1.22-bin.jar) to the folder of your SQL Developer program Open...

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

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

07 May 2013 improves! Download the above modified files. The following ZIP file contains the default Joomla v3.4.x core files and then a copy with my modifications above. I use this to quickly add the relevance option to clients websites as it should work for all...

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

Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 simply take a Joomla install (preferably NOT the most recent version - so that you can force it to update later on) and copy over the core files. Get that working and then begin installing any third-party extensions, and then update Joomla Core (by...

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

Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/articles/microsoft/excel/excel-find-values-in-one-column-that-are-not-in-another.html

06 March 2014 A value equal to "#N/A" means the value was NOT found in column A. Method #2 Be careful with this one because if you copy the formula down, it may automatically modify the range. So the formula in the first row will be =COUNTIF(A2:A100, B2) but the...

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

Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 Beijing Shahezhen Air Base 40°8′57″N 116°19′17″E Beijing Tongxian Air Base 39°48′40″N 116°42′30″E Note that I tend to copy the coordinates off a website which has strange apostrophes and double-quotes. You can change this but remember to put two...

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

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

09 March 2015 This article serves as documentation for a Joomla extension I have released which is a copy of the built-in Joomla Search module but with the parameters embedded (set in the administration section). Why? A client has a repository of PDF documents that...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• 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 my case. Why? My company has started using international country and region names which include foreign characters. When we copy and paste their content into our website, our webpages display a question mark inside a diamond shape instead of the foreign...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• 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 from changing access and adding new people :: Set by "writersCanShare" = false Disable options to download, print and copy for commenters and viewers :: Set by "copyRequiresWriterPermission" = true To do this, set the metadata to the following in the...

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

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

28 January 2019 of this website but I don't expect anyone to trust an executable EXE so here's the code of what it's doing which you can copy and paste to an AutoHotkey script: #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases....

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• 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 So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 an image upload field. Create an entry with one image. Then... Go to Settings Publish Publish Component > Select your report Copy the embed code it pops up with to your clipboard Paste this into a browser Right-click on the image you want and inspect...

• 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 I couldn't find anything on the WWW to document this error. Why? During a data migration, I was using a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a subform with a product line item...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 of linking to the Creator app and some data formatting that I tend to use regularly for my benefit later on when I simply copy & paste the below code templates. Zoho CRM // // initialize v_Index = 0; // // search in Creator v_OwnerName = ; v_AppLinkName...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 and click on the ellipsis/three dots icon Select REST API and enable the API Key, this will return a URL that you want to copy to clipboard or notepad for later use. Set Notification Preferences Finally, here's the function that subscribed my...

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

Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 find myself doing this quite a bit and wanted a quick way of extracting a SELECT list in someone else's form. How? So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with a list declaration and append with a...

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

ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 Click on the clone icon (just below the pencil icon) Give it a new name, possibly the same name but with a suffix such as "Copy", "Clone" or "2" (or your own company initials just to show the customer who's boss). Now click on the pencil icon of the...

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

Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-a-html-entity-decoder.html

27 January 2022 Father & Sons A more comprehensive list v_HtmlEntityNames =...

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