using WHERE IN in SQL

[Wilk Teverbaugh]

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

 

[Ray at]

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]

Thanks Ray.
Very helpful.

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