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

31 July 2024 A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was hitting statement execution limits and rather than proposing an...

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

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 each loops within a for loop. How? The following is 1 fix for the error: Execution Failed UnPredictable exception, Invalid statement found Line:(20) I cannot guarantee that this error doesn't appear for other reasons but I will add to this article if I...

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

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 be identified when using this website, then you can be assured that it will only be used in accordance with this privacy statement. JoelLipman.com may change this policy from time to time by updating this page. You should check this page from time to...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 be identified when using this website, then you can be assured that it will only be used in accordance with this privacy statement. Joel Lipman .Com may change this policy from time to time by updating this page. You should check this page from time to...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 details). I've used a UNION clause which will hopefully make all rooms (even empty ones) display. Note the second select statement (to list all the rooms) has to have the same number of fields as the first statement. This is the final script for the...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 only need one. You can have 1 eTag which combines all input fields into 1 MD5 or hash. Do you need to add a comparing if statement to all fields? Well no again, just compare on the workflow of the audit change. Something along the lines of: Add an Audit...

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

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 to the WHERE clause Specify that the field name in the series fields is not blank So I've added the AND line to the above statement yielding: SELECT _SMDBA_.Incident.[Incident #] ,_SMDBA_.Incident.[Group Name] ,_SMDBA_.Incident.[Close Date & Time]...

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

Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 a GROUP BY a.VisitorIP ORDER BY a.DateTimeStamp DESC) t1 GROUP BY CONCAT(MONTH(t1.Date), ' ', YEAR(t1.Date)) Caused by SQL statement returning first column date as CONCAT(MONTHNAME(t1.Date), ' ', YEAR(t1.Date)) AS Month Solved by changing SQL statement...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 conveying. If you add terms to a covered work in accord with this section, you must place, in the relevant source files, a statement of the additional terms that apply to those files, or a notice indicating where to find the applicable terms. Additional...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 = $expiry_time - time(); $api['jwt']['token']['minutes'] = floor($diff/60); } 6a. Use existing Access Token This if else statement simply says if the token still has at least 5 minutes left, then use the one found at the file location specified earlier....

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

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

12 October 2021 { if(!isnull(r_ShopifyProduct.get("id"))) { // // an error-prone one-liner so that we don't hit an execution statement limit v_ProductSKU = ifnull(r_ShopifyProduct.get("variants").get(0).get("sku"), "UNKNOWN"); m_Sku_IDs.put(v_ProductSKU,...

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

AutoHotkey Ternary Operatorhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ternary-operator.html

27 April 2010 use ternary operators in AutoHotkey. A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages. For Example, the...

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

SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes...

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

Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 What? A really quick article on demonstrating a nested try...catch()... statement working in Zoho CRM. Why? To prove a point to ChatGPT who said this was not possible... and to deal with a scenario which exists for a client of mine. The use-case for my...

• 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 no matching rows (so zero results), BIDS doesn't seem to know what to do with this. We could add a row with a SELECT UNION statement but I found this can be resolved by adding a counter, so the above becomes: SELECT DISTINCT re.[RoomId] ,re.[SiteId]...

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 references (eg. T-SQL is @localvariable, Oracle is :localvariable). I need to change it to a conditional query with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM table1, table2...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 working for you with your query and then for every column of data that you are extracting, you will need to use the case statement to either put the value or your empty row. Here's an example of the query for a timetabling solution with spacing rows...

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

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 If like us, you've made a report containing a link dependent on parameters submitted, we had to apply a similar IIF statement block to the Font color and the Action target as well within SSRS.

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

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 I initially used but my end-users were asking why is it always 0 seconds. This was because we were using the following MDX statement which had seconds as its smallest denominator: ="Execution Time: " +...

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

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

02 January 2012 that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to a number only retrieves the first value...

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