Put them in a recordset and do
<%
Do while not TheRecordset.EOF
Response.Write "The UserID value is " &
TheRecordset.Fields.Item(0).Value
Response.Write "The myUsers value is " &
TheRecordset.Fields.Item(1).Value
Response.Write "The one value is " & TheRecordset.Fields.Item(2).Value
Response.Write "The two value is " & TheRecordset.Fields.Item(3).Value
Response.Write "<br>Okay, on to the next recordset, if there is
one.<hr>"
TheRecordset.MoveNext
Loop
%>
That's one option, anyway.
Ray at home
"Wilk Teverbaugh" <em***@notanaddress.com> wrote in message
news:e7****************@TK2MSFTNGP10.phx.gbl...
How can I iterate through the values returned from the following
statement?
SQL = "SELECT userID, myUsers, one, two FROM users WHERE userID IN (1,2) "
Thanks