I have this code to run a stored procedure... all my stored proc does is SELECT * FROM mytable. This works, but it only returns the first record I use Response.Write(trim(rs("name"))) to print the record. How do I make a recordset for my answer so that I can loop through all the answers??<BR><BR><BR>Set sprs = Server.CreateObject("ADODB.Command")<BR>Set sprs.ActiveConnection = Conn<BR>sprs.CommandType = 4<BR><BR>strCommandString = "testproc"<BR>sprs.CommandText = strCommandString<BR>rs = sprs.Execute