MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 to open... Excel 2007 SP2...with ODBC to... MySQL v5+...hosting database... ActivityLog...contains activity, staffID, resourceID, start time, end time... Report Specification PivotTable Report...resources in row (along the side)......staff in...

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

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 for each r_Data in r_WorkdriveUpload.get("data") { r_Attributes = r_Data.get("attributes"); v_ResourceID = r_Attributes.get("resource_id"); } // // generate permissions to send to workdrive m_Attributes = Map();...

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

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

05 July 2011 I will not be covering them. - W3Schools - Many links listed below will take you to this website, which is an excellent resource for learning JavaScript in depth. Thank You: Chris Malet for creating AutoHotkey Lexikos for AutoHotkey_L Sean & fincs for...

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

JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 data before doing the count, you should get the following error: Warning: mysql_num_rows(): 80 is not a valid MySQL result resource in libraries\joomla\database\database\mysql.php on line 344 INSERT using JDatabaseQuery Note: for Joomla v3.x, use...

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

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

11 September 2024 { m_Header = Map(); m_Header.put("Accept","application/vnd.api+json"); m_Attributes = Map(); m_Attributes.put("resource_id",v_WorkdriveFolderID); m_Attributes.put("shared_type","workspace"); m_Attributes.put("email_id",v_RecipientEmail); // role id 34...

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

Clicking on a weblink returns a 404 errorhttps://www.joellipman.com/articles/cms/joomla/clicking-on-a-weblink-returns-a-404-error.html

06 November 2009 your weblinks and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." Just check that the category the link is in is published.

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 variable. This may be overridden with /-Y on the command line. Other Sources: Download Microsoft Windows Server 2003 Resource Kit Tools (for Robocopy)

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 ZohoCRM.settings.READ ZohoCRM.users.READ Problem: Code 37: The HTTP method PUT is not allowed for the requested resource This was an issue where I was trying to push a Zoho Creator record into Zoho Inventory via an invokeURL with API v2 rather than a...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 only uploads 1 photo. Error(s) Encountered {"code":37,"message":"The HTTP method POST is not allowed for the requested resource"} The endpoint is wrong (for example you don't need the organization ID parameter at the end of the URL)...

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