Search - Joel Lipman .Com

1. Convert a delimited string to table: / Databases /; What? 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 ------ ---------------- ...; Created on 26 October 2012
2. Getting the mysql where in delimited string to work: / MySQL /; What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", ...; Created on 02 January 2012
3. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... count from 0 to 4999 Observation #2: Setting a loop with leftpad limited to 100,000: Our trick of using the leftpad() method to build a list of any number is actually limited to 100000 as you will ...; Created on 31 July 2024
4. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... "Message: " + r_ZohoShipmentUpdate.get("message"); } } } } } } } } Caveat(s): Limited to 250 requests per day (can be upgraded at a cost) Source(s): DH ...; Created on 21 March 2023
5. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... prompt combining any of the following in a table (this is not an exhaustive / limited list). Do note that the images below were generated using MidJourney v4: Type of Photography Nature Photography ...; Created on 11 February 2023
6. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... previous version was limited by our ability to search by product SKU. The new version, taking advantage of GraphQL, will be able to search by SKU and retrieve the correct product ID, variant ID, and inventory ...; Created on 14 February 2022
7. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
8. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... delimited by a comma. However, to match my use-case, I want a list to which I can give it an SKU, and it returns the Shopify Product ID (not of the variant but of the product). In which case, I need ...; Created on 12 October 2021
9. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... v_FormattedString; // yields: 00011,Joel Lipman,"Flat 8|mySpecialComma| House Corner",Brummieland // split into a list (string delimited by commas) l_StringParts = v_FormattedString.toList(); // ...; Created on 26 August 2021
10. ZohoCRM: Process all records of a module: / Zoho /; ... I'm usually asked to update all records and there are at least 10 thousand if not 100 thousand records. The code I use is a for loop within a for loop or in other words 5 pages (as each page is limited ...; Created on 24 August 2021
11. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creator: / Zoho /; ... What Creator understands: FAILS How? So the way to push this value over to Creator is by converting the list to a string... notably comma delimited: // Reading CRM: l_MyMultiPicklist = List:String(); l_MyMultiPicklist.add("Option1"); l_MyMultiPicklist.add("Options ...; Created on 20 April 2020
12. MS Excel - Open CSV with Long Numbers: / Excel /; ... each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be imported as text (the long numbers and phone numbers) ...; Created on 23 July 2019
13. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... this more and more now that API v1 is on the way out and Zoho Deluge by itself is limited somewhat with regards to functionality and record editing when compared to API v2. How? Note that this is ...; Created on 17 July 2019
14. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... : -1.9205, "timezone": "Europe/London", "isp": "University of Birmingham", "org": "The University of Birmingham", "as": "AS786 Jisc Services Limited", "asname": "JANET", "mobile": false, ...; Created on 03 June 2019
15. GDPR Privacy Policy: / Static Items /; ... sponsored by MYCOMPANY or its subsidiaries. LICENSE AND SITE ACCESS MYCOMPANY grants you a limited license to access and make personal use of this site and not to download (other than page caching) or ...; Created on 14 February 2019
16. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... a G-Suite Administrator (see 2b). Scope is a string of scope urls delimited by a space (in this example only one). ISS is the client email taken from the JSON key downloaded from Google. // Build ...; Created on 02 February 2019
17. Zoho Deluge - Get English Ordinal: / Zoho /; ... 2018". Why? Well there's a long a way to do it (but reliable). But being limited to the lines of code you can run (ref. "Maximum number of executable statements", anything that reduces the number ...; Created on 08 November 2018
18. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... value delimited by a period/dot. Base64 decode the second part and this will reveal the user's name and email (along with other profile settings) which you will have to be careful on ensuring this is NOT ...; Created on 31 October 2018
19. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... shall not be responsible for any special, incidental, or consequential damages, including but not limited to personal injuries, damage to property, injury to others, including that to life and health, ...; Created on 24 October 2014
20. T-SQL functions to convert Strings to Tables: / Transact-SQL /; ... start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABL ...; Created on 20 August 2014