Multiple recordsets

Results 1 to 2 of 2

Thread: Multiple recordsets

  1. #1
    Join Date
    Dec 1969

    Default Multiple recordsets

    Hi <BR>I have a stored procedure which has multiple SELECT statements.<BR>Is it possible to get the results of these statements in multiple recordsets, which can be used in the ASP?<BR>If yes please elaborate on it.<BR>Thanks <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Multiple recordsets

    if you are using Access you can not use stored procedures!<BR>on ther other hand if you are using sql you can!<BR>this is the code to get info out of the database<BR><BR>set rs = Server.createobject("adodb.recordset")<BR>sql = "Select * from tablename"<BR>rs.Open sql,"databaseODBC",3&#039note the number 3 is to open the database dynamicly and move forward and backwards<BR>count = rs.recordcount<BR>for i = 1 to count step 1<BR>response.write rs("colName") & "<BR>" & rs("colName2")<BR><BR>next

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts