Assuming results is required, the following 70 results were found.
-
the time of the event e.EventDate, --event details to display e.Note --CTEs defined above are used as the queries for the results FROM Dates d LEFT JOIN Events e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS DATETIME) = d.[Date] --Set the maximum...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
FROM MyTable1 LEFT OUTER JOIN MyTable2 ON (MyTable1.PageID= MyTable2.ArticleID) WHERE MyTable2.ArticleID IS NULL Results STATEMENT1 880 rows 0.187s STATEMENT2 741 rows 49.933s STATEMENT3 741 rows 48.844s STATEMENT4 741 rows 49.603s And Vice-Versa? Well...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention of using MD5 in an encryption task. Why? I'm trying to create an ETag for a synchronization process...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
field: -- Note the alias for the field SELECT COUNT( DISTINCT `my_field`) AS myCount FROM my_table; Method #2: Count from results (my preference): -- Note the alias for the table (select results) SELECT COUNT(t1.my_field) FROM (SELECT DISTINCT my_field...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
its 1st elements name being search_keywords. The following javascript fed throught the address bar would produce the same results: Code: javascript: alert(document.SearchForm.search_keywords.value) MsgBox % pwb.document.SearchForm.search_keywords.value...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
will apply (first time, second time, third time...) with the exception of breaking the rule "No Hacking" which immediately results in a permanent ban: Warning - Depending on how serious a violation is, you may be issued a warning first Muting - Muting...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
substantially all assets of one, or subdividing an organization, or merging organizations. If propagation of a covered work results from an entity transaction, each party to that transaction who receives a copy of the work also receives whatever...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
source directory. -- /XO excludes existing files older than the copy in the source directory. There's a nice output of the results if you run this in a command prompt. The Manual:...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
are: categories contacts newsfeeds weblinks To determine yours, do a standard search on your website and check the search results page. There should be several additional options to your search that will be displayed under the "Search Only:" heading and...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
for each. How? So depending on the number of levels, the count will be with a series if then else statements. See the results/yield section to determine which best fits your scenario: Counting total products: // // count total products for availability...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
:"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters:m_Params.toString() connection:"crm_api_v2" ]; // // retrieve results if(!isNull(r_Coql.get("info"))) { v_MatchedCount = ifnull(r_Coql.get("info").get("count"),0); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
+ r_CreatorFile.File_Download; } } else { v_CrmEndpointUrl = v_ZohoApisDC + "/crm/v2/Results/"+v_CrmResultID+"/Attachments/" + v_ThisFileAttachmentID; // // using a Zoho Oauth connection with scope (ZohoCRM.modules.ALL) r_DownloadFile = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
how an idiot like myself can misread the documentation. This particular article shows you how to customize the search results or response from using zoho.creator.getRecordById(). Why? My use case scenario is that I was trying to build a related list in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the $converted system field is different. Checking the Zoho documentation for an example showing how you can get all results irrespective of whether they are converted or approved: response = zoho.crm.searchRecords("Quotes",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
are different. Having spoken to Zoho and raised with the Zoho Deluge team... Well, they realised they would get the same results, and then suggested looping through all records and creating a distinct list variable... But what if there are 20000+...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_Sku_IDs; info m_Sku_IDs.size(); } Yields something like: { "TEST001": 1234567890123, "TEST002": 2345678901234 } 2 Which results in a map that I can give a Product SKU to and it will return the Shopify Product ID to me. You may have noted also the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
// // fetch all payments against this customer in order of payment reference (oldest to most recent) r_SearchResults = zoho.books.getRecords("customerpayments",v_BooksOrgID,m_SearchCriteria,"zbooks"); if(!isnull(r_SearchResults.get("customerpayments")))...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; if(v_Page==1) { // // get page results x_PaginationResult = x_ResponseBody.subString(x_ResponseBody.indexOf("
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
} // find the logged-in user record ZOHO.CREATOR.API.getAllRecords(config) .then(function(response) { // store the search results into an array var recordArr = response.data; // quick loop to find the preferred name for(var index in recordArr){...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
is TRUE isNull Succeeding is TRUE Equals Blank is FALSE */ I've tried this in both Zoho Creator and Zoho CRM with the same results. I don't code with the method appended at the end of the variable but in more complex method chaining, I can see myself...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *