Assuming loop is required, the following 86 results were found.
-
myself as I'd forgotten how to do this (we're talking technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for automation but sometimes the...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
in the error "Number of statement execution limit exceed Line:(10)" but it will info out each number to increment: // l_Loop = " ".leftpad(5000).replaceAll(" ", ",").toList(); // for each index v_Iteration in l_Loop { info v_Iteration; } // yields an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
quick article if you get the above error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 fix for the error: Execution Failed UnPredictable exception, Invalid statement...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Find in list view occurrences of new names column CountExistingInColumn2( v_Filename ) { v_AlreadyExists := 0 Loop, % LV_GetCount() { LV_GetText(v_Text, A_Index, 2) if (v_Text == v_Filename) v_AlreadyExists++ } Return v_AlreadyExists } ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
an API connection, and then we'll include the code to count the total number of products, and then finallly show the code to loop through all the pages to retrieve every product from the WooCommerce system. API connection in WooCommerce So we need to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
So this is an article to list methods of retrieving the number of files in a folder/directory. Why? Why can't we just use a loop and file pattern native to the Autohotkey programming language: UserFolder:="C:" -- UserFolder := RegExReplace(...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Name and Path,Original Filename,New Filename,FileSize (KB),Reason`r`n" FileAppend, %v_CsvLine%, %v_RunFolder%\Errors.csv Loop % LV_GetCount() { v_FilesTotal := v_FilesTotal + 1 RowNumber := A_Index ;get first selected row RowChecked :=...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
; Create Icons ImageListID := IL_Create(5) Loop 5 IL_Add(ImageListID, "shell32.dll", A_Index) ; -------------------------------------------------------------------------------------- ; Create GUI Gui, New, %Options%, %Title% Gui, Color, %BgColor% Gui,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
A quick article to document a method of looping through all the records of a module and processing these with the ability auto-resume without processing the same record twice. Why? Whether you have a few hundred records, or a few hundred thousand...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
appointment dates l_AppointmentDates = List(); // // initialize Start Date v_GivenDate = '2022-07-21'; // // setup list to loop through (= number of days) l_NumberOfDays = {1,2,3,4,5,6,7}; // // start with first date to add (check if it is a working...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
- Kedar at Nitty-Witty.com ## Procedure for search in all fields of all databases DELIMITER $$ #Script to loop through all tables using Information_Schema DROP PROCEDURE IF EXISTS get_table $$ CREATE PROCEDURE get_table(in_search varchar(50)) READS SQL...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
is the string to start with, the second is the number of spaces to pad with. // // set number of times to iterate through loop (plus 1) v_CheckDaysAhead = 7; // // create a string with this many spaces using leftpad v_GeneratedList = leftpad(" ",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
XorMask, 32*4, 0 ) BlankCursor = 1 ; flag for later } Else If SubStr( Cursor,1,4 ) = "IDC_" ; load system cursor { Loop, Parse, SystemCursors, `, { CursorName := SubStr( A_Loopfield, 6, 15 ) ; get the cursor name, no trailing space with substr CursorID...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Ends First Sunday in November at 2:00 v_LastMonthDate = toTime(zoho.currentdate.toString("yyyy") + "-11-01 02:00:00"); // // loop through each day in a week to get the start and end dates for each v_DayIndex in {0,1,2,3,4,5,6} { v_CheckDateStart =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
(see my 10 mod table below). This article is a quick note (so I never spend as long again) in PHP on how to determine when looping through a loop, which entry was first and which was last. This is incredibly useful for pagination. The Situation I want...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
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 Creator
- 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 Deluge
- Language: *