Delete related records from multiple tableshttps://www.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 LEFT OUTER JOIN `SessionStudent` sst ON sst.sessionId=s.sessionId WHERE s.dateTime >= '2013-02-01 00:00:00' -- yields: sessionID sessionID sessionID --------- --------- --------- 148797 148797 148797 148798 148798 148798 148799 (null) 148799 148800...

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

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 AS newText, `content_column` as oldText FROM `MYTABLE_content` WHERE `content_column` LIKE CONCAT('%',@stringtoFind,'%') -- yields id title OldFoundInOld NewFoundInOld OldFoundInNew newText oldText 1 Article 1 yes no no Hello World Hello World 2 Article...

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 : (DT_DBTIMESTAMP)(SUBSTRING(Date,5,4) + "-" + SUBSTRING(Date,3,2) + "-" + SUBSTRING(Date,1,2) + " 00:00:00") -- Yields: -- [MyDerivedColumnTask1 [4228]] Error: The conditional operation failed. -- SOLUTION: -- a) create a first derived columns task...

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

Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 } } -- put this function at the end of the script. -- usage: SC_Load("C:\*.*", 1) MsgBox, TotalFiles %SC_TotalFiles% -- yields number of files in a directory recursively. Method #4: FileSystemObject ComObjCreate -- usage (see functions below)...

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

htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 site, bear in mind the following is also true: http://www.mysite.com/blog/pretty_much_anything_i_want_to_type_here.html --yields http://www.mysite.com/index.php?myFolder=blog&myFiles=pretty_much_anything_i_want_to_type_here.html Anything not ending in...

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

Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 making has to ensure user's can only see their own projects and not everyone's: SELECT * FROM #__projects ORDER BY name -- yields all projects irrespective of which user is logged in What I want: SELECT * FROM #__projects WHERE user_id= ORDER BY name...

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

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 Simple bit of SQL but as you can see we have a few fields that need decoding (suffixed by "_code"). Run as it is, yields something like the following: sequenceID student_reference student_title_code student_name student_gender_code...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 // print the json echo $json_result; // [OPTIONAL] convert it to an array // $array = json_decode($json_result,TRUE); // yields......... Without cURL You'll have seen this all over the Internet as the accepted solution... Doesn't work for me because...

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 above error when it is attempting to load an XML feed which is mostly in Spanish and breaks at the following XML node: 2 -> yields issue: PHP Warning: simplexml_load_string(): 2 in /home/public_html/my_folder/my_xml_processing_script.php on line 160...

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

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

30 November 2018 { input.Time_field:ui.add(v_CheckTime2b.toString("h:mm") + v_CheckTime2b.toString("a").toLowerCase()); } } Yields the following:

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

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

06 May 2019 = preg_replace("/[^a-z0-9\_]/", "_",$v_Output); // replace any consecutive underscores to a single one (eg. "my_____test" yields "my_test") $v_Output = preg_replace("#((\_){2})\\2+#", "$2", trim($v_Output, "_")); // returns a string return $v_Output; }...

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

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

17 March 2020 {"b","d"}; for each v_FieldName in l_ExcludeFields { l_FieldApiNames.removeElement(v_FieldName); } info l_FieldApiNames; // yields: // a,b,c,d,e // a,c,e // compared to: for each v_FieldName in l_FieldApiNames {...

• 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 v_DownloadUrl = l_BuildUrl.toString("/"); v_FileDownloadUrl = v_DownloadUrl + "?filepath=/" + v_FileInternalName; // // yields something like //...

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

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 + f_MyImages.ID + "/MyImage/image-download/" + v_PublishKey; v_ImageSrc = v_ImageSrc + "?filepath=/" + v_Filename; // yields something like...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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: Convert Map to HTML Table without a FOR loophttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

11 January 2021 m_Data.put("Last_Name","Person"); m_Data.put("id","2"); l_Data.add(m_Data); v_Data = l_Data.toString(); info v_Data; // yields // {"First_Name":"Joel","Last_Name":"Lipman","id":"1"},{"First_Name":"Another","Last_Name":"Person","id":"2"} Some formatting...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 == $v_Key && $v_PostedSecret == $v_Secret) { mail("info@joellipman.com","Post to AscentCloud","Successful Auth"); } } // yields: Successful Auth Caveat Unfortunately, I've titled this article as multi-dimensional but I found that this code doesn't...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 \ -H "X-Shopify-Access-Token: {access_token}" Yields something like the following response: { "image": { "position": 1, "width": 3024, "height": 3024, "alt": null, "id": 12345678901234, "product_id": 9876543210987, "created_at":...

• 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 on) v_TimeZone = v_TimeZone.replaceAll(","," ", true); info v_TimeZone; l_TimeZones.add(v_TimeZone); } //info l_TimeZones; Yields something like: (GMT-10:00) Hawaii Time (GMT-8:00) Alaska Time (GMT-7:00) Pacific Time (GMT-6:00) Mountain Time (GMT-7:00)...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 [ url: "https://zohoapis.com/writer/api/v1/templates" type: GET connection: "joels_connector" ]; info r_Templates; // // yields something like: /* { "total_count": 5, "templates": [ { "created_time": "2019-08-28T16:30:33Z", "modified_time_ms":...

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