Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 break; } } } } else { // store in response text m_Response.put("text","I don't know. Consider doing a Google search."); } } // // output return m_Response; Yields something like the following: Text-Davinci-003: (preceded ChatGPT API) // // initialize...

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

Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 first letter, lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records containing people's names as duplicates, when actually they are the same entity but may have uppercased a...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 Additional: Total product count may differ from the actual product count as products can belong to multiple categories. Consider just using the WooCommerce interface to check the total number of products (wp-admin > Products > All Products). Source(s):...

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

Joomla banners not rotatinghttps://www.joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

20 October 2009 but instead just select a category. Set it to only display 1 banner at a time. If you want other categories to display, consider setting categories as vertical, horizontal and square banners. This means that you can have 3 modules each displaying...

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

SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 name really fast for it to auto-scroll down to the desired name. Our advanced users are exceptions to the rule. Problem Consider the following query: SELECT rb.[GivenDate] , rb.[DateStart] , rb.[DateFinish] , rb.[ContactUsername] , rb.[ContactName] ,...

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

Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 of an issue. I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g environment. How? Consider the following: SELECT ps.person_id, ps.person_name, ( select pa.person_reference as personid, pa.person_text as txt from...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

Zoho Deluge: Generate and Send a CSV via Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 subject: v_Subject message: v_Message attachments:file:v_CSVFile ]; Issue(s): CSV being returned in a single line, consider different methods of inserting a new line: Joel Lipman: ZohoDeluge: Inserting a new line character in a CSV

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