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

27 January 2013 $db->setQuery($query); $my_value = $db->loadResult(); -- using the data echo $my_value; // will equal the retrieved value of "email" Single Row Result - loadRow() This type of query is for when you want any of the values from one resulting row. You will...

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

Alternate row background colour in Reporting Serviceshttp://mail.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 my dataset and "DataSet1" is my dataset -- and Count(Fields!Field1.Value, "DataSet1") returns the maximum number of rows retrieved Yields something like: This is the bottom left of a report where both the above examples (fill and borders) have been...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

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

05 July 2011 MsgBox % COM_Invoke(pwb, "document.getElementsByTagName[input].item[3].value") Controlling the WebPage So far we have just retrieved information from the webpage. Now lets start controlling the webpage. Note - if the JavaScript doesn't end with a...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 // // ********************************************************** // attach to CRM record // Note: Because record cannot be retrieved with search in 1 workflow, run this 2 minutes after Modified_Time // retrieve crm id v_CrmSoID=0; v_RecordID =...

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

Zoho Creator / eBay: Get all Active Productshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 m_ActiveList.put("Pagination",m_Pagination); // uncomment this when all products retrieved and to run this to just get latest products // m_ActiveList.put("Sort","ItemIDDescending"); m_ActiveList.put("Sort","ItemID");...

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

Zoho CRM: Manage a subform using Client Scripthttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 which allows us to compare to the rows already present in the subform // first column to add in this row is start date (retrieved from field "Actual Start Date" on this record) var v_StartDateValue = ZDK.Page.getField('Actual_Start_Date').getValue();...

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

Zoho Deluge: Get All Orders from eBayhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 we are simply getting a CSV with all the order IDs for a particular year output as a spreadsheet. How? Similar to how we retrieved the eBay active listings (see article link above), we're going to use the GetOrders call for order (sales) management. /*...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 r_Account = zoho.crm.getRecordById("Accounts",v_AccountID.toLong()); if(!isNull(r_Account.get("id"))) { v_Output = "Info: Retrieved Record of CRM Account ID: " + v_AccountID; } } // // format output v_OutputHtml = " Hullo World! "+v_Output+" "; return...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 add line items to the invoice m_UpsertCrmInvoice.put("Invoiced_Items",l_CrmLineItems); // // let's add the billing address retrieved earlier to the invoice m_UpsertCrmInvoice.put("Billing_Street",l_AddressStreet.toString(", "));...

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

ZohoCRM & Xero: Function to pull most recent quoteshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 // -------------------------------- Quote Address -------------------------------- // // // let's add the billing address retrieved earlier to the Quote m_UpsertCrmQuote.put("Billing_Street",l_AddressStreet.toString(", "));...

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