Search - Joel Lipman .Com

1. SSRS / MDX Date Queries: / SQL Server Reporting Services /; So I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in ...; Created on 03 August 2011
2. SQL Queries for Statistics: / MySQL /; ... via the browser useragent (VisitorUAgent), the User ID (VisitorID, 0 if not logged in) and of course the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those ...; Created on 13 December 2010
3. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
4. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... article 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 ...; Created on 29 March 2023
5. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... Purpose: Queries DHL for tracking information about a shipment and returns the status code (eg. "delivered") Date Created: 2023-03-21 (Joel Lipman) - Initial release Date ...; Created on 21 March 2023
6. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... the context of ZohoCRM Inputs: string userInput Outputs: map m_Response Date Created: 2023-02-08 (Joel Lipman) - Initial release - Queries OpenAI ...; Created on 06 March 2023
7. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... it's reached the 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 on 01 March 2023
8. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... Queries eBay for all orders given a from and till date Date Created: 2023-02-28 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: ...; Created on 28 February 2023
9. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; What? An article on the reasoning and steps to generate a dataset using Zoho's ANSI-SQL queries to generate the margins of each invoice in ZohoBooks. Why? We need to create a profits/losses dashboard ...; Created on 03 November 2022
10. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... 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 ...; Created on 24 October 2020
11. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
12. MySQL Transactions in PHP: / MySQL /; Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account ...; Created on 14 December 2016
13. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... 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 ...; Created on 24 September 2015
14. Joes Word Cloud (JWC) Download: / Downloads /; ... 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 Joomla! Admin Option: Case-sensitive ...; Created on 07 September 2015
15. JDatabase: using the Joomla database with examples: / Joomla /; ... Joomla lets you build up the queries which admittedly is cleaner and more organized. Here is a query which shows the building methods: // Get a db connection. $db = JFactory::getDbo(); // Create ...; Created on 27 January 2013
16. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; Why? We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return ...; Created on 24 January 2012
17. Basic Oracle Function Structure: / Oracle PL/SQL /; ... I need to submit an Active Directory (AD) username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as ...; Created on 15 January 2012
18. MySQL Group_concat equivalent in T-SQL and Oracle: / Databases /; ... Me 2 Myself 3 I -- to be returned as RowID my_field_name --------- -------------------------- 1 Me,Myself,I Note that the following queries include the nested ...; Created on 28 November 2011
19. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... another dataset (would have to be the first dataset to load so you would need delete your current datasets then add them in the order you want them to load) to get the timestamp of when the queries started. ...; Created on 17 November 2011
20. T-SQL Record Separator: / Transact-SQL /; I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on ...; Created on 11 October 2011