Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 compatibility. - Functions for stripping keywords merged into one. - Date Uploaded: Mon, 14th Mar 2011 1.5.0- Merged all queries for checking 3rd-party content into one SQL query. - Added Joomla! Admin Option: Display SQL query sent to Database. - Added...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 is referred to in widget.html and secondly, the way you retrieve records in the Zoho JavaScript. If you do not include Zoho queries, then I have found the app can be ported between either Creator or CRM (as in pure HTML,CSS and JS). Files referring to...

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

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 article: Zoho Creator: Push to eBay Listings. Getting the Orders in XML format: /* Function: fn_eBay_GetOrders() Purpose: Queries eBay for all orders given a from and till date Date Created: 2023-02-28 (Joel Lipman) - Initial release Date Modified: ????...

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

ZohoCRM: Get All eBay Active Listingshttps://joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 end of the list as per eBay and not what you might have thought it was. /* Function: fn_GetEbayActiveProducts() Purpose: Queries eBay for all active listings Date Created: 2023-03-01 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: -...

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

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

06 March 2023 of ZohoCRM Inputs: string userInput Outputs: map m_Response Date Created: 2023-02-08 (Joel Lipman) - Initial release - Queries OpenAI ChatGPT Date Modified: 2023-03-11 (Joel Lipman) - Stores conversation messages / thread in CRM records - Retrieves and...

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

ZohoDeluge: Check Shipment Status via DHL APIhttps://joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 other statuses there are for a package: /* Function: String fn_DHL_CheckShipmentStatus(string p_TrackingNumber) Purpose: Queries DHL for tracking information about a shipment and returns the status code (eg. "delivered") Date Created: 2023-03-21 (Joel...

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

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

29 March 2023 link above), we're going to use the GetOrders call for order (sales) management. /* Function: fn_GetEbayOrders() Purpose: Queries eBay for all orders for a specified year Date Created: 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29...

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

Code Troubleshooting Checklisthttps://joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 In a database/web environment, have you? Commented out lines that you suspect might be the problem? Able to run the SQL queries directly against the database? Matched the datatypes received/returned by functions, classes and procedures? Confirmed any...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

MySQL Group_concat equivalent in T-SQL and Oraclehttps://joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 3 I -- to be returned as RowID my_field_name --------- -------------------------- 1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data...

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

SELECT COUNT(DISTINCT name) FROM tablehttps://joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 DISTINCT my_field FROM my_table) T1; Ones that didn't work for me: Method #3: By grouping (NOT recommended for more complex queries): SELECT COUNT(my_field) FROM my_table GROUP BY my_field; Additional: Not sure why method 3 is an accepted answer over...

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