Getting the mysql where in delimited string to workhttps://joellipman.com/articles/else/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN DECLARE i INT DEFAULT 0; -- total number of delimiters DECLARE ctr INT DEFAULT 0; -- counter for the loop DECLARE str_len INT; -- string length,self...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Zoho Creator: Add a subform while creating a recordhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 = m_LineItem.get("List_Price"); r_Row.Tax = m_LineItem.get("Tax"); r_Row.Discount = m_LineItem.get("Discount"); r_Row.Total = m_LineItem.get("Line_Item_Total"); c_LineItems.insert(r_Row); } // // create creator record r_Create = insert into Quotes [...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Creator
• Language: *

Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

21 September 2021 v_Minutes + " " + v_MinGrammar + ", " + v_Seconds + " " + v_SecGrammar ; // yields: 0 DAYS, 23 HRS, 54 MINS, 11 SECS Convert Total Minutes to Hours:Minutes This is for other scenarios: v_TotalMinutes = 1100; // // determine hours v_Hours =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Deluge
• Language: *

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 type: GET connection: "joels_connector" ]; info r_Templates; // // yields something like: /* { "total_count": 5, "templates": [ { "created_time": "2019-08-28T16:30:33Z", "modified_time_ms": 1567009834477, "owner_id": "12345678", "last_opened_time":...

• Type: Article
• Author: Joel Lipman
• Category: Zoho CRM
• Language: *

Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://joellipman.com/articles/crm/zoho/zoho-recruit/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

19 October 2022 Year Number of Candidates Next Graduation Year Candidates Graduated in the Past Candidates Graduating in the Future Total Number of Candidates I'll flesh this out some other time but here's the code I used: r_CandidateDetails =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Recruit
• Language: *

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 m_BooksLineItem.put("discount",ifnull(r_CrmLineItem.get("Discount_Percent"),0) + "%"); m_BooksLineItem.put("item_total",r_CrmLineItem.get("Net_Total").toDecimal().round(2)); v_CrmVatPercent = r_CrmLineItem.get("VAT2").replaceAll("[^0-9]","");...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Books
• Language: *

Before and After, Highs and Lowshttps://joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

03 August 2011 SUM(DATEDIFF(MILLISECOND, ExecutionLogStorage.TimeStart, ExecutionLogStorage.TimeEnd)), '00:00:00'), 121) AS TIME) [Total] , COUNT(Catalog.Name) AS Counter FROM ExecutionLogStorage INNER JOIN Catalog ON ExecutionLogStorage.ReportID = Catalog.ItemID...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

The ReportServer Databasehttps://joellipman.com/articles/else/database/the-reportserver-database.html

08 August 2011 Conversions Needed: I want to convert a start and end date to a single time value (hours minutes seconds mseconds) I want to total 3 of the columns (which measure in milliseconds) and convert to a time value with milliseconds showing. Now why don't...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Excel - Check a column for values found in another columnhttps://joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

14 February 2019 "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm shelf allow unity press board wreck shake decay Sheet2 contains the...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Proposed Budget i3 PC under £200https://joellipman.com/component/content/article/proposed-budget-i3-pc-under-200.html?catid=116&Itemid=165

26 January 2013 Protected Enclosure and Emergency Eject - Sony £17.77 Other 2 X Serial ATA Sata Hard Drive Data Cable Lead - Unbranded £0.90 Total £189.75 Confirmed for January 2013 (2 suppliers): Motherboard / CPU / RAM Bundle Intel® Core™ i3-2120 Processor Asus...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

05 July 2011 Basic Webpage Controls COM Object Reference Last edited by jethrow on Wed Jun 22, 2011 10:18 pm; edited 22 times in total Source: Jethrow @ Autohotkey Forums

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

AHK Countdown Tooltiphttps://joellipman.com/component/content/article/ahk-countdown-tooltip.html?catid=48&Itemid=165

17 July 2014 UpdateMessage: ; TOTALS ThisManySeconds:=DateDiff( A_Now, FinalDate, "s" ) ThisManyMinutes:=Floor(ThisManySeconds/60) ThisManyHours:=Floor(ThisManySeconds/3600) ThisManyDays:=Floor(ThisManySeconds/86400) ThisManyWeeks:=Floor(ThisManySeconds/604800)...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

AutoHotkey: Check Windows Folder Sizeshttps://joellipman.com/component/content/article/autohotkey-check-windows-folder-sizes.html?catid=48&Itemid=165

28 January 2019 loops through folders and counts file sizes (including subfolders) LoopThrough: SB_SetText("Reading current directory...") vTotalSize = 0 Loop, Files, %MyBaseDir%\*, F { vTotalSize := vTotalSize + A_LoopFileSize } vListingEntry := " ("...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Zoho Projects: Add a Time Log to an Issue using Delugehttps://joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 find I've included the Hours decimal calculation above but it's not used and just for future reference. The API wants the total hours and minutes in the format "HH:mm" (eg. "34:06" = 34 hours and 6 minutes). Error(s) Input Parameter Missing (6831): Can...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Projects
• Language: *

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 = r_SearchResults.get("data").toJSONList(); for each r_Result in l_SearchResults { // init v_DateTill= "-"; v_QuoteTotalDisp= "-"; v_Index = v_Index + 1; v_RelatedListXML = v_RelatedListXML + ""; // // retrieve v_CreatorQuoteID = r_Result.get("ID");...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Books
• Language: *

Zoho Creator / Shopify: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-get-all-active-products.html

12 October 2021 retrieving 250 per call and using since_id to not list the same one twice. It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map();...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Creator
• Language: *

ZohoCRM: Using Criteria with Module Record Counthttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working examples I use in production systems: Pre-amble: I'm applying to a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho CRM
• Language: *

ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 = m_TranslateStatuses.get(m_ThisInvoice.get("Status")); if(m_ThisInvoice.get("Status") == "PAID") { v_InvoiceTotal = m_ThisInvoice.get("Total"); v_PaidTotal = 0.0; // we have a partially paid status in crm so let's check those payments for each...

• Type: Article
• Author: Joel Lipman
• Category: Zoho CRM
• Language: *

Report Builder 2.0 - Hide Series1https://joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

06 May 2010 data series from an outer join where the joining index value is null. The chart below has 3 series or data fields: Count the total number of incidents logged (Y-axis - data fields) Invidividual the incident(s) are assigned to (Labels - series fields)...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

07 March 2014 forename and surname parameters are not populated. In addition, we also need a second dataset in our report which gets the total count of all the rows matching the selection criteria (the parameters). The concern was that this would make the report just...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB