<div>
If I remember well, with adodb recordset, once you are at eof, you can get the .nextrecordset method of the recordset. This may return what you need.<br />
Otherwise please clarify what you have already as code
</div>


<div>
thanks<br />
<br />
that works for the next one<br />
<br />
what do you suggest for looping through all the recordsets, cant see any good examples online and not sure how to find out how many recordsets there are within my asp code?<br />
<br />
The amount of recordsets returned is dynamic<br />
<br />
Cheers
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a query which uses a cursor/fetch to return a number of records.<br />
It returns them like this<br />
productname budget &nbsp;brand<br />
abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1300 &nbsp; &nbsp; A<br />
efg &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1000 &nbsp; &nbsp; A<br />
productname budget &nbsp;brand<br />
abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1500 &nbsp; &nbsp; B<br />
efg &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1900 &nbsp; &nbsp; B<br />
<br />
In my asp page when I loop through the recordset I just get the first section.<br />
<br />
How do I loop through so that I can also access the second and subsequent set of records<br />
ie in my example above Brand B<br />
<br />
Thanks
</div>
</div>


Hi,

I have a query which uses a cursor/fetch to return a number of records.
It returns them like this
productname budget  brand
abc                   1300     A
efg                   1000     A
productname budget  brand
abc                   1500     B
efg                   1900     B

In my asp page when I loop through the recordset I just get the first section.

How do I loop through so that I can also access the second and subsequent set of records
ie in my example above Brand B

Thanks

If I remember well, with adodb recordset, once you are at eof, you can get the .nextrecordset method of the recordset. This may return what you need.
Otherwise please clarify what you have already as code

thanks

that works for the next one

what do you suggest for looping through all the recordsets, cant see any good examples online and not sure how to find out how many recordsets there are within my asp code?

The amount of recordsets returned is dynamic

Cheers

displaying records via ASP from an sql query which uses fetch/cursor

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.