Search - Joel Lipman .Com

1. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... 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 ...; Created on 11 October 2024
2. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... 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" textarea field. Duplicated ...; Created on 07 April 2022
3. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... Line Item Tax does not submit in API v2.1 Trial and 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 ...; Created on 17 May 2021
4. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; What? This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? ...; Created on 09 May 2019
5. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... 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 ...; Created on 06 May 2019
6. Zoho Deluge - Regex to Strip all non-numeric characters: / Zoho /; ... "Credit Note - 30 Days"; // 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 ...; Created on 25 March 2019
7. GDPR Privacy Policy: / Static Items /; ... 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 otherwise mislead as to ...; Created on 14 February 2019
8. Zoho Deluge - Get Full Day Name: / Zoho /; What? This is a very quick note with the code to retrieve the 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 ...; Created on 08 November 2018
9. Convert to Proper Case in T-SQL: / Transact-SQL /; ... SET @CaseLen = CHARINDEX(' ', @CaseExceptions, @i+1) - @i SET @CaseValue = SUBSTRING(@CaseExceptions, @i, @CaseLen) -- Is this word a UK postal outward code (2 letters ...; Created on 04 June 2014
10. Regular Expressions in SQL: / Databases /; ... 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 ...; Created on 09 January 2014
11. Joomla Development: Possible XML Filters: / Joomla /; ... 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 ...; Created on 17 October 2013
12. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... I have noted that letters immediately following a punctuation symbol, have the UPPERCASE applied: eg. "Andrew Lloyd-Webber", "Marketing Manager (Acting)", "Lipman***Test" or "R&D". As well as alphanumeri ...; Created on 04 October 2013
13. Improve Default Joomla Search: / Joomla /; ... 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: ...; Created on 07 May 2013
14. DBMS Random Reference: / Oracle PL/SQL /; ... yields uppercase string of 10 letters select dbms_random.string('L', 10) myAlias from dual; -- yields lowercase string of 10 letters select dbms_random.string('A', 10) myAlias from dual; -- yields ...; Created on 21 August 2012
15. Could not instantiate mail function: / Joomla /; ... 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 ...; Created on 09 May 2011
16. Formatting a date in an MDX query: / Transact-SQL /; ... letters used are on the MSDN website at http://msdn.microsoft.com/en-us/library/ms146084.aspx NOW() vs TODAY() Noticed this when setting date as the parameter and trying to specify default date as ...; Created on 11 January 2011
17. Webdeveloper-Speak: / Web-Development /; ... An initialism is a phrase 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 ...; Created on 13 July 2010
18. Countdown: Created on 30 December 2018
19. Homepage (default): Created on 10 January 2018
20. Header (Transparent): Created on 01 January 2018