Search - Joel Lipman .Com

1. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... should get the following error: Please ensure that the shipping_address has less than 100 characters. How? If you get the above error, the community forums will advise you to get the ID of the ...; Created on 22 September 2021
2. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... This is a simple article to demonstrate how to type special characters not found on your keyboard or on a Qwerty UK/US keyboard layout. Why? Being able to type international characters from other ...; Created on 03 June 2021
3. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... name. The issue is that if you use zoho.crm.searchRecords() this will work fine for company names without special characters such as the ampersand or parentheses. But what if amongst your records you ...; Created on 28 August 2020
4. Zoho Deluge - Regex to Strip all non-numeric characters: / Zoho /; What A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = ...; Created on 25 March 2019
5. Convert foreign characters to English alphabet: / MySQL /; What? A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I' ...; Created on 13 June 2016
6. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; Applies to: PHP 5.4 MySQL 5.1.4 Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without ...; Created on 25 January 2016
7. DataJumble - Shuffling characters in a data value: / Transact-SQL /; This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it ...; Created on 01 August 2012
8. UTF8 Unicode PHP MySQL for International Characters: / Personal Home Page /; This is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters ...; Created on 22 October 2010
9. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... + v_QuoteRef + ""; // don't forget to escape quote name with CDATA in case of XML banned characters v_RelatedListXML = v_RelatedListXML + ""; v_RelatedListXML = v_RelatedListXML + "" + v_DateTill ...; Created on 30 July 2021
10. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... the double-quotes and no funny characters). It will initialize a project in a folder called something like “/Users//joels_awesome_app” It will then initialize some NPM dependencies and it will ask ...; Created on 24 October 2020
11. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... is used for but I enter the same name in lowercase and replacing special characters with an underscore. eg. "the_joel_lipman_app" Authentication Type: set this to "oauth2" Param Type: set this to "Header" ...; Created on 12 August 2020
12. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... are sending are not in the right format. : The attachment parameter is populated with the file content instead of the internal file name. : The doc parameter contains special characters. Improper ...; Created on 15 May 2020
13. MySQL: Count occurrences of words in a column: / MySQL /; ... have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in descending order. I ...; Created on 12 March 2020
14. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... I found a Zoho page with some other pretty useful regular expressions at https://zoholic.blogspot.com/2015/04/some-usefull-regex-in-zoho.html: Convert a string of characters to a list: v_MyString ...; Created on 31 May 2019
15. 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
16. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... getUrlAlias($p_Name){ // lowercase and trim preceding/trailing spaces $v_Output = strtolower(trim($p_Name)); // replace all non alphanumeric characters (except underscore) to an underscore ...; Created on 06 May 2019
17. Zoho Deluge - MD5 function: / Zoho /; ... be done via the documented methods (base64, urlencode or AES) as this exceeds 255 characters (it could be a multiline but this would defeat the objective of an Etag). How? Well I was going to documen ...; Created on 19 November 2018
18. Display a thumbnail of a Google Drive video: / Google /; What? A super quick article to show how to link to the thumbnail image of a Google Drive file, in this case a video file. How? The hardest part of this is to get the Google Drive File ID (which ...; Created on 13 November 2018
19. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... "id": "1srXLU-lotsofalphanumericcharacters_", "name": "my_video.mp4", "mimeType": "video/mp4" } Additional: Why not? Let's add a description and some security where we disable download, sharin ...; Created on 29 October 2018
20. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !: / Personal Home Page /; What? A quick article to stop me running into this issue again. This article serves to address the issue of importing characters from an XML in a different language character set and trying to load it ...; Created on 02 August 2016