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

30 July 2021 hh:mm a"); // // future proofs v_ExchangeRate = if(v_ExchangeRate == 0,1,v_ExchangeRate); // // transforms if(r_Result.get("Valid_Till") != null) { v_DateTill = r_Result.get("Valid_Until").toDate().toString("dd/MM/yyyy"); } if(v_QuoteTotal != 0) {...

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

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 has occurred during report processing. The Group expression used in grouping 'table1_month' returned a data type that is not valid. My DataSet Query was as follows: SELECT CONCAT(MONTHNAME(t1.Date), ' ', YEAR(t1.Date)) Month,...

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

Warning call_user_func: First argument is expected to be a valid callbackhttps://www.joellipman.com/articles/cms/joomla/warning-call-user-func-first-argument-is-expected-to-be-a-valid-callback.html

22 November 2012 something like the following error: Warning: call_user_func() [function.call-user-func]: First argument is expected to be a valid callback in /home/.../templates/rt_affinity/rt_sectionrows.php on line 311 How? Copy & backup the file...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 > Configuration Wizard > Backup Now Adding articles in Administrator interface: Save failed with the following error: Invalid parent ID. Asset ID is incorrect... Categories > Clear Filter Options > Show All > Tick to select all > Rebuild [does not work]...

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

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

03 April 2009 of how they are packaged. This License gives no permission to license the work in any other way, but it does not invalidate such permission if you have separately received it. d) If the work has interactive user interfaces, each must display Appropriate...

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

JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 try to retrieve the data before doing the count, you should get the following error: Warning: mysql_num_rows(): 80 is not a valid MySQL result resource in libraries\joomla\database\database\mysql.php on line 344 INSERT using JDatabaseQuery Note: for...

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

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

07 November 2011 Note for MySQL solution change 0 to 1. */ =IIF( Parameters!ParameterToCheck.Value"" AND Fields!NOTALPHANUMERIC.Value=0, "Valid", "Not Valid" ) Additional If like us, you've made a report containing a link dependent on parameters submitted, we had to...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 the entire row as a column and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may return special chars rather than Null). My example here is that the first column is our employee...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 function to receive the webhook. Setup a webhook in Xero. [Optional for Method #2] Setup a PHP script on a server that will validate the Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook...

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

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

18 September 2023 m_CreateEstimate.put("date",r_QuoteDetails.get("Created_Time").subString(0,10)); if(!isnull(r_QuoteDetails.get("Valid_Till"))) { m_CreateEstimate.put("expiry_date",r_QuoteDetails.get("Valid_Till").subString(0,10)); } // // ---------------------- QUOTE...

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

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

14 November 2023 info v_Pages; Call with 2 criteria: v_PerPage = 200; v_CountCriteria = "((Quote_Stage:equals:" + encodeUrl("Draft") + ")AND(Valid_Till:greater_than:" + encodeUrl("2023-11-01") + "))"; v_Endpoint =...

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

Functions to convert Hex 2 RGB and vice-versahttps://www.joellipman.com/articles/automation/autohotkey/functions-to-convert-hex-2-rgb-and-vice-versa.html

27 September 2011 and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal to RGB: HEX2RGB(HEXString,Delimiter="") { If Delimiter= Delimiter=, StringMid,R,HexString,1,2...

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

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for selection. Why? This was for a...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 who have a version 6 standalone. Because their site seems to be under construction and links on the WWW are no longer valid, I've uploaded their zip just in case to my own site available for non-registered members at...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 from a specified number of different but similar tables. I'm looking to query the Title and the Introductions of any valid articles from BOTH tables and return one table with everything I want. Consider the following two tables exist: Joomla Articles...

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

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 your website up to standard with all issues addressed and sporting the latest version of the Joomla CMS! UPDATE 2012 - Valid for Joomla 2.5.x but only experimental for Joomla 3.0.x! I still do not recommend using this for your site if you have no test...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const DCX_EXCLUDEUPDATE = $00000100 Const DCX_INTERSECTUPDATE = $00000200 Const DCX_LOCKWINDOWUPDATE = $00000400 Const DCX_VALIDATE = $00200000 ;#End Region ;#Region HitTest Const HTERROR = (-2) Const HTTRANSPARENT = (-1) Const HTNOWHERE = 0 Const...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at "SYS.DBMS_UTILITY", line 114 ORA-06512: at line 1 (System.Data.OracleClient) The Situation I'm using...

• 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 07:30 07:30 07:00 00:00 00:00 37:00 I 03:45 03:30 03:00 03:30 00:00 00:00 00:00 23:00 Method 1. Generate query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user....

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

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 some variables to use DECLARE @SqlToExecute varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid table names) DECLARE Cursor1 CURSOR FOR SELECT TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME FROM...

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