Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 on. This hurts the member as well as the board. No Flaming - Flaming harms the nice atmosphere of TEU. It also causes thread's to go off topic, and most importantly, it hurts the person being flamed. The victom may defend themselves against any...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 l_Messages = List(); // // capture latest message from user v_Message = ifnull(userInput,""); m_Thread = Map(); m_Thread.put("role","user"); m_Thread.put("content",v_Message); l_Messages.add(m_Thread); // // if the message is not blank nor the trigger,...

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

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 r_ChatDetails = invokeurl [ url: v_Endpoint type: GET connection: "ab_cliq" ]; // // let's build up the conversation thread if(!isnull(r_ChatDetails.get("data"))) { for each r_MessageData in r_ChatDetails.get("data") { v_Role = "user";...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 INSERT INTO mydb_upgrade_j25.myprefix_jcomments ( id, parent, thread_id, path, level, object_id, object_group, object_params, lang, userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, published, subscribe, source,...

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

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

04 October 2013 // for cultureinfo and textinfo using System.Reflection; // for looping through properties using System.Threading; // for threading [Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute] public class ScriptMain : UserComponent { //...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 ALTER TABLE `v34_db`.`v34_jcomments` AUTO_INCREMENT=1; INSERT INTO `v34_db`.`v34_comments` ( `id`, `parent`, `thread_id`, `path`, `level`, `object_id`, `object_group`, `object_params`, `lang`, `userid`, `name`, `username`, `email`, `homepage`, `title`,...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 most Web Browsers) The guidelines for "translating" JavaScript can be found in the first post of the COM Standard Library thread (for AHK Basic). Color Legend wrote: Javascript: dark blue AutoHotkey_L: black AHK Basic: green Some other tutorials that...

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

Oracle SQL - Convert given list (CSV) into Rowshttps://www.joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a...

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