Re^3: Changing foreach loop for a while loop

in reply to Re^2: Changing foreach loop for a while loop
in thread Changing foreach loop for a while loop

He changed the SQL statement to use IN, which will match against a list of things, instead using equals to match against one thing
He used positional parameters in the SQL statement: one question mark for each thing to be filled in, in the IN clause
He passed the array to the execute statement, which plugged in one value from the array for each of the question marks in the SQL statement

If your array is huge, the SQL processor may not take that many values in an IN list, in which case you need to break up your array into acceptable-sized pieces.

Caution: Contents may have been coded under pressure.

Comment on Re^3: Changing foreach loop for a while loop

Replies are listed 'Best First'.
Re^4: Changing foreach loop for a while loop by Anonymous Monk on Dec 30, 2004 at 16:55 UTC
If you array is huge, you could also create a temporary table, put the values into the temporary table, and perform a join.	[reply]

In Section Seekers of Perl Wisdom