array array

[cjkenworthy]

I have two dynamically sized arrays with values in:

array1 and array2

previously with only one array I could do:

for I=0 to Ubound(array1)
'Do some SQL using each value in array1
next

BUT now I have two arrays and I want to do a similar thing i.e. for each value in both arrays do some SQL. Something like:

for I=0 to Ubound(array1) and Ubound(array2)
'Do some SQL using each value in array1 and array2
next

This is not proper VBscript of course, so how would i do this? The arrays have an identical number of values:

value1 in array1 corresponds to value1 in array2 etc..

How do I do this without doing a nested 'for' loop which is not what i want.

Thanks for your help,

Chris

 

[JohnYingling]

If they are the same size, use I for both
for I=0 to Ubound(array1)
if array1(I) <> array2(I) then
.....whatever
end if
next

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript