Search - Joel Lipman .Com

1. Zoho Books: System Values Maps: / Zoho /; ... Map fn_GetSystemValues() Trigger: Snippet to be used at beginning of code to get dynamic maps of system values Purpose: Taxes, Currencies, Payment Terms, Sales Persons, and Nominal Accounts Inputs: ...; Created on 07 November 2023
2. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... it's usage: // somewhere in the beginning l_ShopifyPictures = List(); v_ListingPublishKey = "AAAAABBBBBCCCCDDDDEEEFFFGGGGHHHIIIJJJKKLLLMMMNNOOOPPPQQWRRRSSTTUUVVWWXXYYZZ122345567890"; if(!isnull(input.Main_Photo)) { v_Filename ...; Created on 17 October 2021
3. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... them once, store them as a map on your function if you don't want to use up these 2 every time your sales team push a CRM Sales Order to Zoho Books. Or leave as 2 calls at the beginning of your function ...; Created on 24 September 2021
4. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... Quote". Within your function you can use the following as a reference. In theory, you could loop through each submitted quote but I do a call at the beginning of each iteration of the loo ...; Created on 06 December 2020
5. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
6. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... being this script. Complete the global variables at the beginning of the code specific to your app and the rest should work... // specific to this app $CLIENT_ID = ''; // expecting *.apps.googleusercontent.com $CLIENT_SECRET ...; Created on 31 October 2018
7. Basic Android App using Google Maps and Current Location: / AndroidOS /; ... Focus the cursor on the word and hold down the key and press Enter, then import each class: Your code will now include the imported classes near the beginning, so TEST it! ...; Created on 10 October 2014
8. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
9. Regular Expression Basic Usage Examples: / Web-Development /; ... \+ This expression matches the plus character '+' in the following string: abc+def The expression does not match any characters in the string: abcdef Beginning of Line Anchor Use ...; Created on 28 October 2013
10. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... at the beginning of a line. exceptionArray_this = new string[] ; foreach (string myValue in exceptionArray_this) { ...; Created on 04 October 2013
11. A for loop within a for loop in MS-DOS: / MS-DOS /; ... the following loops through directory for any file beginning with Reference FOR %%A IN ('DIR InitializingFile*') DO ECHO %%A -- yields: InitializingFile_123.csv InitializingFile_456.csv -- the ...; Created on 03 October 2013
12. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; ... right, as we got the last occurrence counting from the beginning rather than the end, so we still need to work out the starting point: SELECT LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)) -- ...; Created on 28 January 2013
13. Delete related records from multiple tables: / MySQL /; ... sst ON sst.sessionId=s.sessionId WHERE s.dateTime >= '2013-02-01 00:00:00' Testing first I should put this at the beginning of the article as it is what you should do before running a DELETE FROM ...; Created on 11 January 2013
14. Background Gradient Disappears on Long Pages: / Cascading Stylesheets /; ... would appear to be fool proof because of the "background:#f7f7f7" specified at the beginning of the code but it is not. My only solution was to propose to set the background as white (#f7f7f7 - white with ...; Created on 20 November 2012
15. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; ... was successful" or "No sorry you're going to have to go back to the beginning and try that again."... This isn't a solution that sounded good enough for our customers. The Workaround we actually went ...; Created on 04 November 2011
16. T-SQL Record Separator: / Transact-SQL /; ... Marker */ As I mentioned at the beginning of this article, I am comparing on Day names. The above query generates a last column which is either empty or says "Separator Marker". Based on the CTE above, ...; Created on 11 October 2011
17. List all cron jobs for all users: / Linux /; ... Annoyingly necessary. tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning ...; Created on 04 May 2011
18. Windows 7 and Google Chrome incognito mode by default: / Google /; ... that if in point 4, if there are any spaces in that value, you should add a double-quote character to the beginning and end of the location of chrome.exe (for example: "C:\Users\My User Name\AppData\Local\Google\Chrome\Application\chrome.exe" ...; Created on 24 March 2010
19. Embed an FLV file into a web page: / Hypertext Markup Language /; ... anything on your webserver. I like to use flowplayer for this example but my own systems can't use a solution as crude as this. Copy the below code (beginning and ending with object tags) ...; Created on 09 March 2010
20. Outputting PHP files into different file formats: / Personal Home Page /; I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do ...; Created on 12 February 2010