Assuming query is required, the following 116 results were found.
-
recurse OPTION (MAXRECURSION 100) I'd appreciate if you bear with me as I add captions to the below screenshots: Design the Query: So copy the above text, click on query builder and "edit as text", then paste it into there. When you ok this you should...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
so use it... How? Well I started with the method #1 listed here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
In not as many words as others, here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
that you have to do this as the super admin to get organization level messages. But in ths example below, we're going to query a message to the ChatGPT bot: // // initialize m_Response = Map(); v_Message = message.trim(); v_ChatID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
= $000C Const WM_GETTEXT = $000D Const WM_GETTEXTLENGTH = $000E Const WM_PAINT = $000F Const WM_CLOSE = $0010 Const WM_QUERYENDSESSION = $0011 Const WM_QUIT = $0012 Const WM_QUERYOPEN = $0013 Const WM_ERASEBKGND = $0014 Const WM_SYSCOLORCHANGE = $0015...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
clients. eg. "JoelLipman_BooksConnector". Homepage URL: put our corporate website URL, this is for developers who need to query what this app belongs to or does. eg. "https://www.joellipman.com/" Authorized Redirect URIs: for this put in one of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
This is an article of code snippets to query a Zoho Bookings instance from within Creator. This one focuses on getting the available slots. Why? This is for a Creator app which had a form to allow customers to make a booking based on the configuration...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
page, returns these in JSON as a Zoho Map datatype. How? I'm not going to go into detail on how I create an access token to query the eBay Trading API as you can read this in my article: Joellipman: Zoho Creator: Push to eBay Listings. You will note...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
from Monday 00:00 v_FirstDateOfWeek = zoho.currentdate.toStartOfWeek().addDay(1).toString("yyyy-MM-dd"); // // build up COQL Query v_CoqlQuery = "select Start_DateTime, End_DateTime from Events where Created_By='" + v_UserID + "' and ("; v_CoqlQuery =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
+ r_GeoCode.get("latitude")); l_Params.add("lng=" + r_GeoCode.get("longitude")); l_Params.add("by=position"); } // // query with a GET method r_Timezone = getUrl("http://api.timezonedb.com/v2.1/get-time-zone?" + l_Params.toString("&")); // // if we got...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// Generate your access token to connect to Xero and query Xero records // See my article: https://www.joellipman.com/articles/crm/zoho/zoho-deluge-sync-to-xero-api.html // v_TenantID = ""; v_AccessToken = ""; r_Response =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
first I'll give some brief instructions on how to get an API key from DHL as a developer and then I'll include the code to query the shipment status based on a tracking number. Becoming a DHL Developer Browse to https://developer.dhl.com/user/register...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to list errors and query order line item IDs (ErrCode: 21917182) - Modified to check that there are some orders. More Info: - API Explorer Test Tool:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the creation of an invoice but lots of my clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
extras Just making a list of things that at-time-of-print of this article aren't in the official Zoho documentation: Query the documents folder r_MyDocuments = invokeurl [ url: "https://www.zohoapis.com/books/v3/documents?organization_id=123456789"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= 1; // // map to retrieve all records (to include approved and converted records, this needs to be specified as the query value) m_IgnoreRestrictions = Map(); m_IgnoreRestrictions.put("approved","both"); m_IgnoreRestrictions.put("converted","both"); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *