Assuming loop is required, the following 85 results were found.
-
using System.Globalization; // for cultureinfo and textinfo using System.Reflection; // for looping through properties using System.Threading; // for threading [Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute] public class...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
a Creator report to the user, that they can select (tickbox) multiple records in that report, and then have a button that loops through all the selected (ticked) records. The example below documents a report of Quotes where we want to merge all the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
handling of new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were trying to loop through rows of a CSV file which contained addresses which in turn contained commas. Saving this as a CSV and asking Deluge to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which have workflows triggered from many deltas/changes. Why? Some...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Shopify. Why? The use-case was that I wanted to search Shopify using a Product SKU. Community forums could only suggest looping through all the products. I then felt that actually I just need the Product IDs. This method could do with some refinement...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
going to use a free TimeZone API (one that returns a timezone given a lat/lng). The added feature is that we are going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
below). // ****************** CODE USING SEARCHRECORDS **************** // // init v_RecordID = 1234567890123456789; // // loop through 5 pages of 200 records = 1000 records l_Pages = [1,2,3,4,5]; // // set search criteria v_SearchCriteria =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the displayed rows (not been deleted) var l_existingSubformRows = ZDK.Page.getField('Deployment_Rate_Log').getValue(); // loop through to exclude any rows we don't want based on criteria l_NewSubformRows = new Array(); for (i = 0; i...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
void fn_AB_GenerateVacanciesCandidatesAssociations() Workflow: - Trigger: Standalone function triggered on execute Purpose: Loops through all candidates and creates records referring to the Candidate Ref and Job Opening Date Created: 2023-02-02...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to check if there are already records in the system with that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
that particular data appeared in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
folder to keep in Green and the one to delete in Red. - Lists failed deletions if there are any. - Changed browsing code to loop through folder of files to REMOVE. - Changed code to loop through an array of files rather than the directory. - Added...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
the MySQL Forums: BEGIN DECLARE i INT DEFAULT 0; -- total number of delimiters DECLARE ctr INT DEFAULT 0; -- counter for the loop DECLARE str_len INT; -- string length,self explanatory DECLARE out_str text DEFAULT ''; -- return string holder DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
v_UidStr.substring(6,8) ); l_Parts.add( v_UidStr.substring(8,10) ); l_Parts.add( v_UidStr.substring(10,12) ); // loop through parts for each v_Element in l_Parts { v_Remainder = v_Element.toLong() % 26; l_Output.add( l_Alphabet.get( v_Remainder ) ); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
0006 Test Product 1 TEST001 test2@joellipman.com 0007 Test Product 1 TEST001 test2@joellipman.com The code is a for loop which iterates through each row, assigning an entry for a new product or account, and specifying the quantity for each. How? So...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
with a ListView with rows that can be double-clicked to open the profile. As an overview: Setup a standard AutoHotkey GUI Loop through Google Chrome Profile folders named "Profile 1", "Profile 2", etc. Scan the preferences file for JSON key "name" and...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
v_FileInternalName = row.Upload_File; // looping through rows here but it wants the internal name here eg. "1234567890123_temp.pdf" // // build the URL l_BuildUrl = List:String(); l_BuildUrl.add(v_CreatorDownloadBase); l_BuildUrl.add(v_AppOwnerName);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a list to hold the keys which we will use to sort in ascending/descending order and a map created to hold all the records. Loop through the sample map to create the new map we can sort as well as to add keys to the list declared previously. Sort the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a text editor, then escape the double-quotes, then prepend with a list declaration and append with a end of list suffix; loop through removing HTML tags and while we're at it, storing it in a list for Zoho Deluge: First of all, here's the HTML SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= 32; // // set to the Account record of our organization v_OrgAccountRecord = 123456789012345678; // // loop through all users r_Users = zoho.crm.getRecords("users"); if(!isnull(r_Users.get("users"))) { for each r_User in r_Users.get("users") { // loop...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF