Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 Select Properties. Select User Mapping. Map the login to the database they will have access to. Tick the boxes for role membership next to public and db_datareader. Confirm by clicking OK. You should get something like the following: Database-level role...

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

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

06 March 2023 = 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, send to...

• 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 // // build params of request m_Params = Map(); m_Params.put("model", "gpt-3.5-turbo"); m_Message = Map(); m_Message.put("role", "user"); m_Message.put("content", v_Question); l_Messages.add(m_Message); m_Params.put("messages", l_Messages); // //...

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

Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 m_Attributes.put("shared_type","workspace"); m_Attributes.put("email_id",v_RecipientEmail); // role id 34 is view only on the file (see below for further permissions) m_Attributes.put("role_id",34); m_Data = Map(); m_Data.put("attributes",...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 m_Attributes.put("shared_type","everyone"); // 34 for files // 6 for folders m_Attributes.put("role_id","34"); m_Data = Map(); m_Data.put("attributes",m_Attributes); m_Data.put("type","permissions"); m_Params = Map(); m_Params.put("data",m_Data);...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 weblinks as well Form attributes I have set these to the following: action = /index.php?option=com_search method = post role = search Issues Further searches do not include the same filters. This will be because the setting to display search areas has...

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