SQL Result Loop

[rmock]

I am running an SQL script and can easily write results as long as there is only one result:

FileWriteLine($TextTemplate,$adoRs.Fields(1).value & ', ' & $adoRs.Fields(2).value)

Can anyone give me any good direction on how to create a loop when the number of results is not constant? I am fairly new to autoIT and I know the following is far from correct. When I run this script it seems to be an infinite loop:

$countBan = 0
While 1
$countBan = $countBan + 1
If $countBan < 0 Then ExitLoop
WEnd

While Not $adoRs.eof
For $i = 0 To $countBan
$ln[$i] = $adoRs.Fields(1).value
$fn[$i] = $adoRs.Fields(2).value
Next
WEnd

For $i = 0 To $countBan
FileWriteLine($TextTemplate,$adoRs.$ln[$i] & ', ' & $fn[$i])
Next

[water]

Check this

You loop throught the recordset until recordset.EOF = True, using recordset.Movenext to get the next record.

Details can be found here.

[kylomas]

rmock,

Look at this code

$countBan = 0
While 1
$countBan = $countBan + 1
If $countBan < 0 Then ExitLoop
WEnd

When does $countban < 0 test true?

kylomas

edit: additional info

2ND - you need to advance the record pointer, as water has pointed out

3RD - you are using the variable $countban as both a scalar variable and an array

4TH - For further help you should post runnable code.

Edited December 14, 2012 by kylomas

[jchd]

There is a much simpler code to fill an array (possibly empty or very large) with the whole resultset:

$aRows = $adoRS.GetRows()

[water]

Thanks jchd,

learned something new today