Assuming loop is required, the following 80 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
- 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
- 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
- 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
- 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
- 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
- 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
-
; 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
- 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
- Language: *
-
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
- 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
- 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: *
-
Method 1. Generate query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance of the previous version of this query was pretty...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
ReturnedHTMLTableRows=%ReturnedHTMLTableRows% StringSplit,ReturnedHTMLTableRows,ReturnedHTMLTableRows,| RowIndex:=0 Loop, %ReturnedHTMLTableRows0% { RowIndex++ ReturnedHTMLTableColString:=ReturnedHTMLTableRows%RowIndex% ; split the row into columns...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB