Search - Joel Lipman .Com

1. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer is 2 separate API calls after ...; Created on 18 September 2023
2. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... ...; Created on 01 March 2023
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. Joes Chart Generator (JCG) Downloads: / Downloads /; VersionPlatform ChangeLogOptions1.0 + Group all the data by a specified column + Generate interactive flash charts- Date Uploaded: Wed, 15th Sep 2010 Download; Created on 07 September 2015
10. CSV Chart Generator: / Product Documentation /; Originally dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate ...; Created on 04 September 2015
11. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read ...; Created on 14 May 2013
12. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; ... How? Perhaps we should determine the position of the last needle first (reverse the haystack string and find needle): DECLARE @Haystack VARCHAR(31); SET @Haystack = 'String1.String2.String3.String4'; -- ...; Created on 28 January 2013
13. 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
14. 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
15. Joe's CSV Chart Generator (JCG: / Product Documentation /; ... Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What ...; Created on 26 May 2010
16. Another ASCII Extended Character Set for PC: / Windows OS /; Typing an ASCII character In DOS: Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178) In Windows for a DOS character: Hold ...; Created on 14 April 2010
17. Creating a Top 10 chart with less code: / Personal Home Page /; ... ten chart of your data (eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each data exists, sort it in reverse order so ...; Created on 18 February 2010
18. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... l("T"," ").getPrefix("+").toString(v_TimeFormat),"-"); // // generate XML related list response // don't forget to escape quote name with CDATA in case of XML banned characters v_RelatedListXML = v_Related ...; Created on 06 August 2024
19. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 10 columns called "Untitled-1". I enter some labels in the first column. These will be keys later on to link my report to so keep them short without any special characters. I then saved this table with ...; Created on 25 July 2024
20. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... do some further calculations based on a surcharge rate held in a custom module. The custom module could only be created in Zoho Books at time of print but Zoho Inventory is where our workflow and code ...; Created on 23 May 2024