Prabhat wrote:
"Arpan" <ar******@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com... Assume that an ASP page has 3 SQL queries. Can a recordset object be
populated with the records of all these 3 queries at the same time?
Please note that the 3 queries are distinct queries, not related to
each other in any way. Also please note that I am not talking about
populating the recordset with the records of the 1st query, then
closing it & again opening that recordset, populating it with the
records of the 2nd query so on & so forth.
Thanks,
Arpan
Hi Arpan,
I think you have 3 Different SQL Query and dont want to use 3
recordset but you want to open / populate ONLY ONE recordset that
consistes of all 3 SQL Query?
If that is the case then use NextRecordset method of ADO. Let me know
if this help.
THis will not work with Access, which does not support batch queries. Of
course, since we don't know what database is being used ...
Arpan, please. Always specify the database type and version you are using in
EVERYdatabase-related post you make. Do not assume that we will know your
database by your previous posts:
a) we may not have read your previous posts
b) you may be using a database that is different from the one used in your
previous posts
You will avoid receiving unusable replies if you remember to do this. Make
it a header that you copy/paste into each of your questions to the group.
As Ray mentioned, it may be possible to construct a union query that will
retrieve your results in a single recordset. However, this will only work if
the queries are all being run in the same database (Access) or on the same
server (SQL Server)
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.