Three boxes, two roll over, one falls outhttp://mail.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 So this is an article to note an oddity when I was working with a Yootheme template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It...

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

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

14 March 2013 will fail and stop the task (based on default settings). Additional -- Take a "dd/mm/yyyy" string and convert to date (when (DT_DATE)ThisDate by itself doesn't work) (DT_DATE)(SUBSTRING(This_Date,1,2) + "/" + SUBSTRING(This_Date,4,2) + "/" +...

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

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

23 April 2013 This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 to identify the data column being processed private int[] inputBufferColumnIdx; // Create variables used in debug logging (when it is enabled) private byte[] emptyBytes = null; private const string DebugLogEventName = "JL - Mixed Case Component Debug";...

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

Zoho Deluge - Get Refresh/Access Token API v2http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 that API v1 is on the way out and Zoho Deluge by itself is limited somewhat with regards to functionality and record editing when compared to API v2. How? Note that this is using Zoho Deluge and not another server-side script such as PHP to send the...

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

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

14 November 2023 columns) with equals and starts_with conditions. The only operator that is supported for encrypted fields is equals. When you use "equals" for multiple conditions, and if one of your conditions is (Company:equals:ABC), the response will contain records...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttp://mail.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 this is a one-click accept or decline then done. One of the biggest hurdles here, which may sound trivial, was the response when an end customer clicks on either the accept or decline button. Using ZohoFlow or other Zoho app for a webhook response,...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 these requests, eBay has implemented a push notification system. This system alerts all eBay Developers Program applications when a user has requested the deletion of their personal data and closure of their eBay account. This article explains the...

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

Zoho CRM Client Script: Map Quote to Invoicehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 This is an article to apply an automation that when creating an invoice in CRM from a related quote, it maps in the fields. Why? The process should be that you go to the CRM quote record and click on "Convert" > then select "Invoice", and it should map...

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

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 get the official response on what impact this has on refreshing the token. Then I'll put all my notes I made along the way. When a Zoho Books bank feed stops syncing in the United Kingdom, there are a few possible causes. Sometimes the issue is with the...

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

SQL: Use CASE for Relevance columnhttp://mail.joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 -- where @ThisSearch is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID, columnFullName, CASE WHEN columnFirstName LIKE @ThisSearch THEN 20 WHEN columnFullName LIKE @ThisSearch THEN 10 WHEN columnLastName LIKE @ThisSearch...

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

Error 404 Component Not Found when enabling SEF URLshttp://mail.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

02 September 2015 subdomains where this template was installed. I installed some terrible 3rd-party SEF plugins to correct the situation but when I moved my test site to live at www.joellipman.com (instead of being on http://test1.joellipman.com), I found I could disable...

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

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

18 December 2024 Function: void automation.fn_Quotes_OnEdit(int p_QuoteID) Label: Fn - Quotes - On Edit Trigger: Used in a workflow when a quote is modified Purpose: Actions when a quote is modified Inputs: int p_QuoteID - the ID of the CRM Quote Record Outputs: void...

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

Privacy Policyhttp://mail.joellipman.com/static-items/privacy-policy.html

30 May 2009 This privacy policy sets out how Joel Lipman .Com uses and protects any information that you give Joel Lipman .Com when you use this website. Joel Lipman .Com is committed to ensuring that your privacy is protected. Should we ask you to provide certain...

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

Crystal Reports: Exporting to Excel omits column headershttp://mail.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 but none of them produced consistent results. One solution was to untick "Simplify page headers" on the Excel Format Options when you export the report. Because our report is exported via a web-based system, this extra dialog doesn't appear when our...

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

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

29 March 2011 want to list the equipment and features found inside the room. Problem #1: More of an aesthetic problem than functional but when the room didn't contain equipment (or the admins had not added the equipment info on the system), it just showed the heading...

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

What's the problem? Amusing computer issueshttp://mail.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 access to a secure application "So that's all installed for you. I just need you to restart your computer now and tell me when that's done.". "I've done what you said but it's still not working". "From my logs, you haven't restarted this machine in a...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Stop Excel Row Height Self-Adjust on Refreshhttp://mail.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 Date, Reservation, Contact, JobTitle, CHAR(10) + Dept + CHAR(10) AS Dept FROM my_imaginary_table WHERE Contact='Joe' Now when Excel refreshes the data, it acknowledges new lines (the "CHAR(10)" as with other cell data). Quite a lot of spacing (the...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• 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 first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty result set. Furthermore I am using this stored procedure in a SQL Server...

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

Error 1065: Query was Emptyhttp://mail.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects. Developers will have told the system...

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