Zoho Creator: isBlank and isNull: Before or After?https://joellipman.com/articles/crm/zoho/zoho-creator-isblank-and-isnull-before-or-after.html

10 February 2025 A really quick article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {......

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

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

04 February 2025 IS NOT NULL OR JSON_EXTRACT(old.`attribs`, '$.spfeatured_image_alt') IS NOT NULL); Get Search to find ALL articles I noticed that if I search for some of my articles, they weren't appearing in the smart search but I could see them in the category blogs....

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

Add the website name to the page title in Joomla!https://joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

06 September 2009 As I like doing this for this particular website (my personal one) in every version of Joomla it's been upgraded to, I've noticed some differences that I've noted down below. Specific Joomla Template Providers Everytime I update this article, Joomla...

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

Formatting a date in an MDX queryhttps://joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 expression letters used are on the MSDN website at http://msdn.microsoft.com/en-us/library/ms146084.aspx NOW() vs TODAY() Noticed this when setting date as the parameter and trying to specify default date as today's in the format DD/MM/YYYY. Googled...

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

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

29 March 2011 suggest you use method #1. Issues I ran into: I replaced the empty dataset with the message "None" using Method #2 above. I noticed when a textbox is hidden, the next textbox moves to fill up the space... There are some suggestions on the net but they...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 images: 150x100, 200x150, 300x200, and 1:1 Output Thumbnail Quality: allows you to specify smaller/bigger files (haven't noticed much difference in how they display, only in the actual size the image uses of disk space). Output Thumbnail File Type: can...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 on the page (not on a link as this will take you to another page) and the field returns to displaying "Name:". Why? I've noticed a lot of solutions now use JQuery or Mootools but most of these will not work in Internet Explorer 7 which is unfortunately...

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

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 thats with thicker than stock pads Done. Here's a video and I will try to post some more: {youtube}tG6Yg0H11U8{/youtube} Noticed a problem with jello. This problem was due to the new propellers I was trying (9" nylons) which I replaced with the stock...

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

Excel - Check a column for values found in another columnhttps://joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 formatting which colors the cells red or green for demonstration purposes): If you understand this article, you may have noticed that the range of words to find from Sheet2 in this screenshot are from the cells B1:B4... This is because I already had...

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

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by...

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

Does Google Chrome Frame really improve performancehttps://joellipman.com/articles/google/does-google-chrome-frame-really-improve-performance.html

23 September 2009 The jury's still out on this one. I have noticed a slight improvement in my page loads but will have to carry out proper tests on the weekend. Instructions to a hard-coder The Google Chrome Frame (or ChromiumBrowser) is quick to enable. Simply ask your...

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