Alternative method of displaying Unicode in Autohotkey GUIhttps://joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 ¿ inverted question mark 169 A9 U+2310 ⌐ reversed not sign 170 AA U+00AC ¬ not sign 171 AB U+00BD ½ vulgar fraction one half 172 AC U+00BC ¼ vulgar fraction one quarter 173 AD U+00A1 ¡ inverted exclamation mark 174 AE U+00AB « left-pointing double angle...

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

Pancakeshttps://joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 the batter hits the hot pan, tip it around from side to side to get the base evenly coated with batter. It should take only half a minute or so to cook; you can lift the edge with a palette knife to see if it's tinged gold as it should be. Flip the...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 What? A frustrated article about an issue that took me a fair few hours to resolve. So I'm putting it here as I thought I covered this previously but couldn't find it on my website. This was previously titled something along the lines of truncating to 2...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 15 modules and about 15 plugins (excluding the core modules/plugins) and managed to recreate this error. I disabled half of these but still got the error. Cleared the expired cache but still got the error. I then uninstalled half of these (including...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 AND ref.[RefSystem] = 'myPayrollSystem' Yes well obvious to some but then you google the above and you get half a million results. That's a lot of reading so here's the simple fix for my issue: Returning an error: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone]...

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

SSRS Stop Scrolling Behindhttps://joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 the images of the corners and sides of the report. It looked beautiful if simply displayed on a single page (the top half of the page) as long as the end-user doesn't scroll. If the page was scrolled, what should display went behind my report and...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• 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 A3), why not? Tested on the legs as they're cheaper than a new shell... has a shine and sparkle of my old car And the top half of the Phantom shell Was really worried but it's coming out really nicely Sparkly! and Shiny Hmm... wrong way round, the...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 } updatedAt } } } } I found this is the same as the inventoryQuantity so might as well reduce those costs (by almost a half!). Source(s): Shopify Partners - How to Generate a Shopify Access Token (legacy) Shopify Community - API To Search Products By...

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

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records and that's only half of the production system's contacts. I needed a quick bit of code to find any duplicates, all within the Zoho Creator app...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 (r_QuoteDetails.Grand_Total != undefined) { v_QuoteGrandTotal = r_QuoteDetails.Grand_Total; } // determine deposit amount (half of grand total) but on the final balance invoice, we are deducting the deposit v_DepositAmount =...

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