Zoho Deluge: Determine your Statement Execution Limithttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

31 July 2024 will info out each number to increment: // l_Loop = " ".leftpad(5000).replaceAll(" ", ",").toList(); // for each index v_Iteration in l_Loop { info v_Iteration; } // yields an incremental count from 0 to 4999 Statement Execution Limit is 10000 If the...

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

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 would otherwise ask is the data value reliable if it's blank? The long way of doing this I would have called this article "Iteration within SQL Server Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining...

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

MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 AND YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION' ) AS 'Monday', ( SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) AS SecondsElapsed FROM...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 v7 style if(l_NewLineItems.size() > 0) { // // build request to send to CRM v7 // m_RecordData should have value from last iteration m_UpdateQuote.put("Subject",m_RecordData.get("Subject")); m_UpdateQuote.put("Quoted_Items",l_NewLineItems);...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 Part 2 is dedicated to content migration, the commands are split to do about 5000 articles on each iteration so as to avoid session timeouts and memory issues. Edit the script, renaming the database and table names used (DO NOT CONFUSE THE FOLLOWING...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 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 loop to retrieve all the data in each record r_QuoteDetails = Partners_Quote[ID == r_Quote.ID];. In the example...

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

Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 headers:m_Headers ]; //info "Response from eBay:"; //info x_ResponseBody; // // get pagination results from the first iteration/page if(v_Page == 1) { // // get page results x_PaginationResult = x_ResponseBody.subString(x_ResponseBody.indexOf("

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