Search - Joel Lipman .Com

1. MySQL: Count occurrences of words in a column: / MySQL /; What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count ...; Created on 12 March 2020
2. Zoho Deluge - Counting in a Map dataType: / Zoho /; What? A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine ...; Created on 02 September 2019
3. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; What? A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below ...; Created on 03 June 2019
4. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
5. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add ...; Created on 24 September 2015
6. AHK Countdown Tooltip: / AutoHotkey /; Applies to: Microsoft Windows 7 Enterprise AutoHotkey (see code for AHK version) What? Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better ...; Created on 17 July 2014
7. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; ... UserFolder := RegExReplace( MyInputField, "\\$") ; gets rid of trailing slash if required -- Method #1 count := 0 Loop, %UserFolder%\*.*, 0, 1 count++ -- note for future use: ; if A_LoopFileAttrib ...; Created on 04 June 2013
8. Country Lookup by IP address CSV: / MySQL /; ... allocated country. Our use here was to create a refreshable country by IP address list that we can use when parsing our website logs to check where visitors were from. Note: we also use and love ...; Created on 17 March 2013
9. Search a database for a value and count matching rows: / Databases /; What? We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called ...; Created on 05 November 2012
10. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE [usp_ListDistinctValuesAndCounts] ( ...; Created on 26 October 2012
11. Counting the occurence of a word within a string: Benchmark: / Personal Home Page /; I added this article because when I was only trying to look up how to do this, this nut "the Storyteller" went and carried out a benchmark test on the most popular ways of counting the occurrence ...; Created on 06 September 2009
12. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... type: GET connection: "joels_connector" ]; info r_Templates; // // yields something like: /* { "total_count": 5, "templates": [ { "created_time": "2019-08-28T16:30:33Z", ...; Created on 21 October 2021
13. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... v_Position = ifnull(p_Position, 1); v_ShopifyProductID = ifnull(p_ProductID, 123456789012); r_PortalListing = Portal_Listing[Shopify_Product_ID == v_ShopifyProductID]; if(r_PortalListing.count()>0) { v_Filename ...; Created on 17 October 2021
14. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... */ v_Page = ifnull(p_Page,1); v_PerPage = ifnull(p_PerPage,200); m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken ...; Created on 13 October 2021
15. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map(); m_Header.put("Content-Type","application/json"); // // ...; Created on 12 October 2021
16. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... "Currency": "USD", "id": "123456789000000005" }, { "Currency": "USD", "id": "123456789000000006" } ], "info": { "count": 200, "more_records": true } } Which ...; Created on 08 October 2021
17. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... City Another City Test State Test Zip Another State Another PostCode Test Country A different Country But the packing slip would display the Ship to address as the ...; Created on 07 October 2021
18. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... m_Currencies; // // get Books ID for a currency from an CRM account record r_AccountDetails = zoho.crm.getRecordByID("Accounts", 9012345678901234567); v_BooksCurrencyID = m_Currencies.get(ifnull(r_AccountDetails.get("Currency"),"GBP")); info ...; Created on 24 September 2021
19. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... "item_id": "456789012345678901", "discount": 0, "quantity": 1, "description": "A test product description" } ], "shipping_address": { "address": "Test Street", "street2" ...; Created on 22 September 2021
20. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... get given eTag l_FieldsToMonitor = List(); l_FieldsToMonitor.add(input.Title); l_FieldsToMonitor.add(input.Contact); l_FieldsToMonitor.add(input.Account); l_FieldsToMonitor.add(input.Opportunity); v_eTag ...; Created on 19 September 2021