Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How? The first...

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

DBMS Random Referencehttps://www.joellipman.com/articles/database/pl-sql/dbms-random-reference.html

21 August 2012 -- yields number between 1 and 1000 select dbms_random.string('U', 10) myAlias from dual; -- yields uppercase string of 10 letters select dbms_random.string('L', 10) myAlias from dual; -- yields lowercase string of 10 letters select...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

Joomla Development: Possible XML Filtershttps://www.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

17 October 2013 Forces the value to be a floating point value BOOL Forces the value to be true or false WORD Strips anything that is not letters (including numbers) ALNUM Forces the value to be alphanumeric (Letters and numbers only. No special characters) CMD Forces...

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

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 objectionable, and does not consist of or contain software viruses, political campaigning, commercial solicitation, chain letters, mass mailings, or any form of "spam." You may not use a false e-mail address, impersonate any person or entity, or...

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

Webdeveloper-Speakhttps://www.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 or multi-word name that has been abbreviated to the first letter of each word, and is pronounced as a series of individual letters. For example HTML (the computer language used to author webpages), is an initialism of HyperText Markup Language, and is...

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

Formatting a date in an MDX queryhttps://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 a specific format, try... =Format(now(), "ddd, dd MMMM yyyy HH:mm:ss") =Format(now(), "dd/MM/yyyy") The reserved expression letters used are on the MSDN website at http://msdn.microsoft.com/en-us/library/ms146084.aspx NOW() vs TODAY() Noticed this when...

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

Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 770 username:mail /var/spool/virtual/domain.com/* 660 username:mail 8) Ensure your hostname does not contain any upper case letters. 9) Make sure that your main server IP has a reverse lookup on it.

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

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

07 May 2013 to list matches that sound like the search term. Levenshtein: Allows for typos and matches to words that are 1 or 2 letters mistyped. Grammar: Account for singular/plural, past/present, and noun/adjective/verb forms. Referencing: If this is a search...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 Task: Transformation: Data Viewers Script Transformation Editor: Input Columns Additional "Features" I have noted that letters immediately following a punctuation symbol, have the UPPERCASE applied: eg. "Andrew Lloyd-Webber", "Marketing Manager...

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

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 @i+1) - @i SET @CaseValue = SUBSTRING(@CaseExceptions, @i, @CaseLen) -- Is this word a UK postal outward code (2 letters and number(s)) IF ((LEN(@CaseValue)

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 the PHP $p_Name here is the title of your article or product that will be changed into a string of only letters, numbers and underscores. Note that the PHP doesn't need a database connection here: function getUrlAlias($p_Name){ // lowercase and trim...

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 error resolved this one. Submit the line item but instead of "line_tax", replace this with "Line_Tax" (note the capitalized letters). I have included this in the example above. Line Item Tax doesn't display at line item lvel Previously submitting no tax...

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

GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 and went to the SSL/TLS manager and clicked on "Manage SSL sites" Opened the first certificate file (the one with numbers, letters with extension CRT), copied the contents to clipboard then pasted under "Install an SSL Website" into the "Certificate"...

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

Zoho Deluge: Convert Hex to RGBhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-hex-to-rgb.html

11 October 2024 values for you. How? Very quickly, we take each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to convert to an RGB subset, the 1st value is to be...

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

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

13 March 2025 to eBay's validation challenge code. In the Verification token field, enter a unique 32–80 character token containing only letters, numbers, underscores (_), or hyphens (-), which eBay uses to verify ownership of your endpoint. After entering your...

• 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 VOSK instead: Install Vosk + Dependencies pip3 install vosk pip3 install soundfile # to apply punctuation and capitalized letters within transcript output pip install deepmultilingualpunctuation Download an English Speech Model: mkdir -p ~/vosk-models...

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

Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 all rows where the student surname does NOT contain a letter or number -- eg. O'Brien will NOT be returned as it contains letters MySQL And my favorite. Note the circumflex as we are still excluding non-alphanumeric rows. SELECT * FROM Students WHERE...

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

Zoho Deluge - Get Full Day Namehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

08 November 2018 full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How? Well a few methods....

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

Zoho Deluge - Regex to Strip all non-numeric charactershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

25 March 2019 // we want the 30 from the above string How? I'm aware of the getAlphaNumeric() function in Zoho and I can remove the letters with removeAllAlpha(): v_PaymentTermsAlphaNum = v_PaymentTerms.getAlphaNumeric(); // yields CreditNote30Days vPaymentTermsNum =...

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