Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 ]; info r_AddTags; } } } /* {"code":"INVALID_DATA","details":{"api_name":"id","json_path":"$.tags[0].id"},"message":"invalid tag id","status":"error"} -> Error was due to trying to assign map with removed key to a new map. -> Solution was to remove the...

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

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 info r_DelRow; Error(s) Encountered {"status":"failure","summary":"LESS_THAN_MIN_OCCURANCE","data":{"errorCode":8504,"errorMessage":"The parameter CONFIG is not proper(Has not been sent or is less than required count)"}} Crazy! sometimes the invokeUrl...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 api_name:'data'... But this is shortcode, not an invokeURL. { "code":"INVALID_DATA", "details":{ "api_name":"data" }, "message":"invalid data", "status":"error" } How? I recall covering this solution before but it boils simply down to the...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 Popup a confirmation box to proceed or cancel. Popup the email from CRM mailer with the to email address, bcc, subject and message content already populated. How? The example from the Kaizen series uses a record with canvas mode applied; but I wanted to...

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

How to redirect the visitor after the contact pagehttp://mail.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 = ‘index.php?option=com_contact&task=view&contact_id=’. $contact[0]->id .’&Itemid=’. $Itemid; mosRedirect( $link, _THANK_MESSAGE ) replace that code with the URL for the contact Thank-you page as defined as follows: $link = sefRelToAbs(...

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

Creating a Profile Plugin for Joomla 1.6http://mail.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 with this allergy?" PLG_USER_PROFILE5_FIELD_ALLERGYTIME_LABEL="Time With Allergy?" PLG_USER_PROFILE_FIELD_ALLERGYTIME_MESSAGE="Select one of the options" PLG_USER_PROFILE5_XML_DESCRIPTION="User Profile - JoelLipman.Com Plugin"...

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

Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 disappearing and reappearing, the content is what I don't want to lose. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const PM_NOYIELD = 2 ;#End Region ;#Region Windows Messages Const WM_NULL = $0000...

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

Basic Webpage Controls with JavaScript / COMhttp://mail.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 will be based on (and can be used with) the Search Forum webPage. Our first example will use the alert() method to pop-up a message box that says Hello World! Simply put this javascript in your URL Address bar and hit enter: Code: javascript:...

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

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

02 September 2011 (:) we expected for Oracle. Passing in Variables I've been told that SSRS does not understand OUT variables. For a success message to be returned based on the status of the stored procedure, please view my article SSRS Retrieving Oracle Stored Procedure...

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

No rows returned in Oracle causes SP to failhttp://mail.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 rows if there are no matches (not a blank row either) as one of my reports uses a row counter to display a "No data found" message when no rows are returned. This does not affect the above problem as the stored procedure simply fails and discontinues...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Print Directory Contents to a Filehttp://mail.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 I could have used %Comspec% or even %windir%\system32\cmd.exe but with some group policies, you will get an "access denied" message. If you don't have a C:\windows folder, then find your "cmd.exe" program and change the path in the above instructions...

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

Restore MSSQL Error: Database is in usehttp://mail.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 page. From the Restrict Access option, select Single. If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections, click Yes. Restoring in SSMS, Right-click on the...

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

SSIS Convert a string into a datehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 + "-" + SUBSTRING(Date,1,2) + " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833) to column "This_Date" (3932)....

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

Change the default Joomla Error templatehttp://mail.joellipman.com/articles/cms/joomla/change-the-default-joomla-error-template.html

04 April 2013 Backup the file \templates\system\error.php Create a replacement file called error.php including the below code Change the message "The Page you are looking for..." to what you want. Change the link "www.joellipman.com" to the "www.yoursitename.com"....

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

SSRS: Performance Improvements: SELECT TOPhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 OR @GivenDOB = '') AND (@GivenRef'' OR @GivenForenames'' OR @GivenSurname'' OR @GivenDOB'') For usability, we put a message just below the header which was an expression detailing what the report was displaying, so for example: -- If setting the limit...

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

AHK Countdown Tooltiphttp://mail.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 Pictures\Win7_ScrSvr\BU_Core_CMYKportraitbigwithborder.jpg" ; Default Message reference ThisMessageIndex:=0 ;...

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

SITS: Export field code and namehttp://mail.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 XSLT but watch your datatypes Notes: We did not find a way to return the code when the lookup failed, only an alternative message "*LookupFailed*".

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttp://mail.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 curl_setopt($ch, CURLOPT_POST, TRUE); // TRUE to do a regular HTTP POST. curl_setopt($ch, CURLOPT_POSTFIELDS, $api_message_xml); // In my case, the XML form that will be submitted curl_setopt($ch, CURLOPT_TIMEOUT, 15); // Target API has a 15 second...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

CSS Add Text to Breadcrumb Link with a Transitionhttp://mail.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 is not a smooth one. If anyone has a tried and working solution to the width transition then feel free to comment/message me (please test before sending it to me as I'm aware of width transitions for div layers). DEMO: See my JsFiddle...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Creator: Create a Widget which uses JavaScripthttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 in a new tab and authorize the connection by clicking Advanced -> Proceed to 127.0.0.1 (unsafe)”. This message is somewhat out of date but follow the following instructions to preview your app: Open a browser and Ensure you type the preceding “https”...

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