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 Creator: Embed Forms/Reports on a Page: / Zoho /; What? Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template ...; Created on 05 May 2022
13. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... the Add button below it Link it if applicable to your super admin account Create an app, a form and publish it in Zoho Creator Create an app by clicking on Create App then go into the app and ...; Created on 31 March 2022
14. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... up to 2, right through 3 to 1, then down to 5... Now it all blends together: Error(s) Encountered: DisplayPort to DVI cable doesn't work: I get what I pay for I guess... I went for a slightly more expensive ...; Created on 12 March 2022
15. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... = Document[Parent_Record == v_CrmContactID.toString() && Document_Name == r_Attachment.get("File_Name")]; if(r_CheckIfDocumentAlreadyExists.count() > 0) { r_NewDocumentRecord = Document[ID == ...; Created on 11 March 2022
16. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... Admin API scopes": This will be dependent on what your app needs to do. In this example, mine needs to sync orders, products, customers, and some reports; the other things like discounts, fulfillment ...; Created on 14 February 2022
17. Zoho CRM: searchRecords with sorted results: / Zoho /; ... loop through all pages for each v_Page in l_Pages { r_SearchResults = zoho.crm.getRecords("Accounts",v_Page, v_PerPage, m_SortCriteria); // loop through all results per page for each r_Result i ...; Created on 10 February 2022
18. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... Deluge - Some Useful Regular Expressions list but I felt this deserved its own article. Why? A client wanted the discount displayed on a template and if they gave 10% discount, it would display ...; Created on 08 February 2022
19. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... the header section) but then they changed address and couldn't change the template. So they had something like: $ $ $ $ $ 11 My Street, My City, My State, My Zip, My Country They wanted to get ...; Created on 25 January 2022
20. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... */ v_Found = 0; v_Updated = 0; v_Page = 1; v_PerPage = 10; m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken ...; Created on 22 January 2022