ASP Classic RecordSet loop
Posted on 2015-02-19
I have a page in asp that calls different recordsets, In order to write this on a simple txt page we created this loop:
Do until rs_usermap.EOF
lista(cont) = " + "& rs_usermap("QFrsvalue")
valor = rs_usermap("QFrsvalue")
rs =Mid( valor, InStr(valor, "rs_"), InStr(valor, ".Fields")-2)
inicio = InStr( valor, "(" & Chr(34))+2
fin = InStr(valor, "Val")-3
field = Mid(valor, inicio, fin - inicio)
If Not rs_Beneficiary.EOF then
Select Case rs
If Not rs_attorneys.EOF then
Now, the problem I have is that "rs_attorneys" has more than 1 row on the recordset.
How could I program the loop so that it writes all the rows on "rs_attorneys" and then move to the next recordset ?