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

14 May 2013 AS MyCount FROM DMExtractEmployeeTable e2 LEFT JOIN DMExtractReferenceTable r2 ON e2.CodeType LIKE r2.MapIn -- FIXED!!! WHERE e2.ID=e1.ID GROUP BY e2.ID,r2.MapIn ) AS MatchingRecordsCount FROM DMExtractEmployeeTable1 e1 LEFT JOIN DMExtractReferenceTable...

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

Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 to Joomla CMS v2.5.14 What? This article is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered"...

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

Joes Revolver Map (JRM) Downloadshttps://www.joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 alignment parameter - Enhancement: Restored colors and new colors given - Enhancement: Compatible with Joomla v2.5.x - Fixed: Backwards compatible parameters updated - Date Uploaded: Fri, 16th Jan 2015 Download 1.5- Enhancement: Updated widget from...

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

Joes Youtube Plugin (JYP) Downloadshttps://www.joellipman.com/component/content/article/joes-youtube-plugin-jyp-downloads.html?catid=92

07 September 2015 Plugin Class Suffix - Added Joomla Admin Panel option: Border Color - Added Joomla Admin Panel option: Border Style - Fixed parameters to display as saved (Was saving but not showing). - Date Uploaded: Thu, 17th Feb 2011 1.0.2- Added Joomla Admin Panel...

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

CSS Center an iFrame Horizontally and Verticallyhttps://www.joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 also works on iframes: HTML: Horizontally and Vertically Centered Iframe CSS: body { background:red; } iframe { position: fixed; top: 50%; left:50%; transform: translate(-50%, -50%); } DEMO: See my JSFiddle demo: https://jsfiddle.net/Jlipman/u5sew3ob/21...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 client to enter their own text to display to their users. A preset form/page with openUrl could do the same thing but it's a fixed width/height and question of preference. There are cases however when the openUrl method might be better, for example, for...

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

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 that this error doesn't appear for other reasons but I will add to this article if I encounter any. This is simply how I fixed this error on this occasion. Consider the following code which loops through some Creator records, then loops through one of...

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

Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ItemReturnCategories"); // // include fixed price items m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage);...

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

Zoho Inventory: Mark a package slip as delivered and shippedhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 the sales order to an invoice and created a package slip for it. The invoice was then sent (payment=unpaid). Not sure which fixed this. {"code": 4,"message": "Invalid value passed for JSONString"}: Quick fix by settings the parameters in the invokeUrl...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 but "When any selected field is updated" and then selecting the fields "Status", "Balance", and "Notes". (not sure which one fixed it but I now add all three): Error(s): Workflow did not trigger and did not receive even the email included in my custom...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 Date Modified: 2023-03-20 (Joel Lipman) - Check if payment has already been recorded before creating a new one. - Fixed reference_number being included on customer payment. Date Modified: 2023-03-21 (Joel Lipman) - Added if conditions to not adjust...

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

Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 not saying this is the solution to whenever you get the above error; I'm just saying this what I was doing and this is what fixed it when I ran into this error: // initialize m_QuoteRecord = Map(); // // build quote request...

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