Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section here where I demonstrate how to upload photos to be hosted by the Zoho Analytics app. Uploading the images to be hosted by Zoho...

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

Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 up to 200, v6 up to 10k, v7 up to 100k) m_Params = {"select_query":"select Product_Name, COUNT(id) 'Frequency' from Products where Product_Name is not null group by Product_Name limit " + v_PerPage + " offset " + v_Offset}; r_CoqlUniqueProducts =...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 the user first loads up the webpage containing the widget, 10k images are downloaded. I have put in a lazy loading process where it will load the first few images and as the user scrolls down the dropdown, more are loaded. This still gets buggy on...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 - Day 3. Can you rewrite this using headings and punctuation so that it makes sense to other trainees reading it? Rephrase where necessary and include details from the official documentation for [Topic] where applicable. // wait for completion and...

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

Joomla - How to preview module positions in a given templatehttps://www.joellipman.com/articles/cms/joomla/joomla-how-to-preview-module-positions-in-a-given-template.html

02 April 2010 was asked "... how do you find out where the positions are, like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after your website URL:...

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

Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 Warning: implode() [function.implode]: Invalid arguments passed in /home/.../public_html/includes/router.php on line 325 Where "..." is the path on your server. If you're writing a component, then ask yourself if you really need the router.php file....

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

MySQL Commands to display all columnshttps://www.joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 data_type TEXT across all databases: SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS value FROM information_schema.COLUMNS WHERE DATA_TYPE='text' ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all columns that had the...

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

SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 , rb.[DateFinish] , rb.[ContactUsername] , rb.[ContactName] , rb.[Room] , rb.[BookingNotes] FROM roombookings rb WHERE rb.[GivenDate] BETWEEN @GivenDate AND @ToDate AND rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows This returns...

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

MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 I have another system which starts on Monday and ends on the following Sunday. The solution below is for the opposite, where the week starts on the previous Saturday and ends on the last working day of the week. The Solution Where "givenDate" is the...

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

About 5 seconds worth of funhttps://www.joellipman.com/articles/microsoft/sharepoint/about-5-seconds-worth-of-fun.html

21 November 2012 Directory. I know the AD domain and username, show me the person! http:///Person.aspx?accountname=MYDOMAIN\myusername (where "" can be domain\username or just username. Master of the Universe!...

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

SQL: Use CASE for Relevance columnhttps://www.joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 be a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID, columnFullName, CASE WHEN...

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

MySQL: Find all non-alphanumeric rowshttps://www.joellipman.com/articles/database/mysql/mysql-find-all-non-alphanumeric-rows.html

09 September 2013 with URL friendly characters. How? -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that are non-alphanumeric but ignore underscores SELECT * FROM...

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

Disable User Registration in Joomla 1.5 - Configuration Filehttps://www.joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

08 October 2013 but in the database. Open the database to the Joomla 1.5.x website Browse the table "jos_components" (or "#__components" where "#_" is the site table prefix. default is "jos"). Open the row where name="User Manager" Set the value under params for...

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

SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 my_table GROUP BY my_field; Additional: Not sure why method 3 is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why...

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

Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html

30 May 2009 either version 3 of the License, or (at your option) any later version. You are to maintain copyright information where credit is due. The scripts and programs are distributed in the hope that they will be useful, but WITHOUT ANY WARRANTY; without even...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 I'm going to make our system recognize SWF files (by default these are disallowed): Firstly: Add the following line to somewhere in the LocalSettings.php file in the web root folder where your MediaWiki is installed: $wgFileExtensions[] = 'swf'; or if...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 of the video unless it was an AVI file that we converted to FLV. The quality was horrible. Then we moved to Camtasia Studio where their videos were displaying in good quality but as SWF files. This extension includes the default settings for...

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

Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 Couldn't find this anywhere on the net and kinda needed it so am making a note of how to do it here. The issue is that I wanted to make my autohotkey program change the image that the mouse hovers over (within it's own GUI). No third-party component or...

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

Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 { $this_value=trim($row['column1']); $this_value_num=mysql_num_rows(mysql_query("SELECT column1 FROM table1 WHERE column1='$this_value'")); if (($this_value!="") && ($this_value_num>5)) { $this_value_num=sprintf("%010d",$this_value_num);...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 contact details) Rates (usually £9/hour for non-e-commerce sites or £15/hour for e-commerce) Similar looking websites where layouts/colour schemes can be adapted Explain accessibility and usability industry standards. (includes iPhone compatibility and...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *