Getting the mysql where in delimited string to workhttps://joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 I must confess that the bulk of this work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN DECLARE i INT DEFAULT 0; -- total number of delimiters DECLARE ctr INT DEFAULT 0; -- counter for the loop DECLARE str_len...

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

Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 GO -- Create Stored Procedure CREATE PROCEDURE dbo.usp_MakeTableTemp @SchemaTableName nvarchar(100) AS BEGIN -- Variables used DECLARE @ColName varchar(50); DECLARE @TableName varchar(50); DECLARE @TableDeclaration nvarchar(4000); DECLARE @SqlToExecute...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 : parameter 2 for dbms_random function v_returnedval VARCHAR2(255) := ''; -- v_returnedval : value to be returned BEGIN IF p_original_value IS NULL THEN v_returnedval := NULL; ELSIF p_original_datatype='INT' THEN -- Check Parameters and assign proper...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

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

01 February 2013 to link this to mySQL databases. How? So this is how I did it, I found the process rather straightforward anyway so let's begin: Download the JDBC Driver for MySQL (Connector/J) connector from http://www.mysql.com/products/connector/ [Optional Step]...

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

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

07 May 2013 Add the option to select by relevance to the CASE order statement: switch ($ordering) { // BEGIN: joes new ordering option case 'relevance': $order = 'relevance DESC'; break; // END: joes new ordering option case 'oldest': $order = 'a.created ASC';...

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

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

17 November 2013 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 itself) and then any updates to the third-party...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 Categories -- unstable Content Weblinks 3rd-party: JComments Here's a less brief outline of the whole process: Pre-Notes: To begin with, ensure that no extra new users are created in the v34 system other than the user who is installing it. Preparation:...

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

Zoho Deluge: Loop through 30 Minute Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 which populates as: 08:00, 08:30, 09:00, 09:30... 19:30, 20:00. // get rid of all picklist options clear Time_field; // begin populating options thisStartHour = thisServiceRecord.Opening_Time.toString("HH"); thisClosingHour =...

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

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

06 May 2019 IF EXISTS incrementUrlAlias; DELIMITER | CREATE TRIGGER incrementUrlAlias BEFORE INSERT ON my_table_name FOR EACH ROW BEGIN declare original_url varchar(255); declare url_counter int; set original_url = new.url_alias; set url_counter = 1; while exists...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 the "State" field on the Lead record. // // ************************************************ // determine customer timezone: BEGIN // v_CustomerTimeZone = ""; // // build up address from Lead to geocode l_LeadAddress = List();...

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

Amazon Kindle: Send PDFs to your Kindlehttps://joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 is also quite straightforward. All you need to do is send the PDF file to your Kindle email id. It is here that things might begin to seem a bit complicated in that not many might be aware Amazon allots an email address to every Kindle owner, and that...

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

ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 "\", " ") } v_NewFile := SubStr(v_NewFile, 1, InStr(v_NewFile, ".",, -1)-1) v_DisplayName := A_LoopFileName ; if file names begin with exclamation mark (for saleslogix) if(InStr(v_NewFile, "!")>0) { v_NewFilePt1 := SubStr(v_NewFile, InStr(v_NewFile,...

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

Zoho Books: Generate Bank Text File for Downloadhttps://joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 Open the file / Download via Browser We're going to use an openUrl() function here in the hopes that your browser will just begin downloading it (failing this it will open up in the browser and staff member will need to be instructed on how to 'File >...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 notifications or they have successfully opted out of the notifications, the keyset/App ID is activated, and they can begin making API calls." How? Let's cover the first preamble points here: While completing the form, the developer subscribes to eBay...

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

Strip HTML in MySQLhttps://joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 IF EXISTS fnStripTags; DELIMITER | CREATE FUNCTION fnStripTags( Dirty varchar(4000) ) RETURNS varchar(4000) DETERMINISTIC BEGIN DECLARE iStart, iEnd, iLength int; WHILE Locate( '', Dirty, Locate( '', Dirty, Locate( '

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