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

22 August 2012 p_original_value IN VARCHAR2, p_original_datatype IN VARCHAR2, p_original_range_1 IN VARCHAR2 DEFAULT NULL, -- no effect on strings p_original_range_2 IN VARCHAR2 DEFAULT NULL -- no effect on strings ) RETURN VARCHAR2 IS v_char_at NUMBER := 0; --...

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

T-SQL: Parse an XML valuehttps://joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores...

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

Counting the occurence of a word within a string: Benchmarkhttps://joellipman.com/articles/web-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 went and carried out a benchmark test on the most popular ways of counting the occurrence of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by Split+Count took :...

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

Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://joellipman.com/articles/crm/zoho/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

01 September 2021 how do we guarantee that the system will understand the date correctly? How? It may be that when obtaining a date string and applying the method .toString("dd/MM/yyyy") is dependent on the settings. But making a date into a SQL format or from largest...

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

Convert a delimited string to tablehttps://joellipman.com/articles/database/convert-a-delimited-string-to-table.html

26 October 2012 This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and...

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

Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Use this one to specify a default command timeout for the connection. Please note that the property in the connection string does not supercede the individual command timeout property on an individual command object....

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Zoho Deluge - Some Useful Regular Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 post on some other regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in...

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

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

20 September 2021 for this process). So first off, here's a reminder on the function that generates an access token from a refresh token: string API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api =...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 contact record Button Code: /* ******************************************************************************* Function: String fn_SendCreditApplication(Int p_ContactID) Label: Fn - Contact - Send Credit Application Trigger: Off a button on the contact...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 description, and set category to "Standalone": I'm calling mine "fn_Deals_RetrievePipeline" Give it the following code: string standalone.fn_Deals_RetrievePipeline(String p_DealID) { /*...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 = "fn_Accounts_GetCreditSafe"; // Prepare the parameters for the function call var m_Params = { "arguments": JSON.stringify({ "p_AccountID": v_EntityID }) }; ZOHO.CRM.FUNCTIONS.execute( v_FuncName, m_Params ) .then( function( r_SubData ){...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table: DMExtractEmployeeTable...

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

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

05 September 2013 If you allow percents (%) or apostrophes (*) then you are asking for trouble. Note my redirect for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example...

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

Batch Process to rename multiple files using Windows DOShttps://joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. This example will rename files which contain the string " (Copy)" and replace it with nothing (so removes it). The...

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

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

27 January 2022 document a HTML Entity decoder in Zoho Creator. Why? Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " and obviously want to display these as decoded HTML entities. (Zoho if you're listening)...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 and call it "Signature Image": /* ******************************************************************************* Function: String fn_Workdrive_HostImage(string p_DownloadImageUrl, string p_WorkdriveFolder) Label: Fn - Workdrive - Host Image Trigger:...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 TO JOOMLA v2.5.x -- -------------------------------------------------------------------------------- -- NOTE: Replace string "mydb_livecopy_j15" to your Joomla 1.5.x database name -- -- -- (example: "anolddatabase") -- 9 occurrences -- NOTE: Replace...

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

Parse a HTML Table into a ListViewhttps://joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 - Needle1 NeedleMarker := Needle2 ReturnedHTMLTable := SubStr( Haystack, Needle1, NeedleLen ) ; split the table into rows StringReplace,ReturnedHTMLTableRows,ReturnedHTMLTable,,|,A ReturnedHTMLTableRows=%ReturnedHTMLTableRows%...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 '/access_token.dat'; 2b. Specify the impersonator Now for testing purposes you should leave this next variable as an empty string. If you leave this blank, the script will run through and connect to Google Drive using the Service Account. The script...

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

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

15 May 2020 through rows here but it wants the internal name here eg. "1234567890123_temp.pdf" // // build the URL l_BuildUrl = List:String(); l_BuildUrl.add(v_CreatorDownloadBase); l_BuildUrl.add(v_AppOwnerName); l_BuildUrl.add(v_AppLinkName);...

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