small dooubt on recordset

[G]

Hello Friend,

I have a doubt.
I am connecting to mysql db and there is only one table and i am retrieving
the data like city, state, county, etc.. from db to comboboxes. so i am
using one recordset for each retrivel and showing into combobox. it is
going slowly.

SO what happens if i use multiple recordsets in single ASP page?

So I think we can use only one recordset for all the data retrievel from the
db?

waiting for your reply.

Gaffar.
Thanks

[Raj]

Store recordsets as array using function GetRows of recordset object.

This will be pretty faster.

HTH

Raj.
"G" <su**********@gmail.comwrote in message
news:ul**************@TK2MSFTNGP04.phx.gbl...

Hello Friend,

I have a doubt.
I am connecting to mysql db and there is only one table and i am
retrieving the data like city, state, county, etc.. from db to comboboxes.
so i am using one recordset for each retrivel and showing into combobox.
it is going slowly.

SO what happens if i use multiple recordsets in single ASP page?

So I think we can use only one recordset for all the data retrievel from
the db?

waiting for your reply.

Gaffar.
Thanks

[Bob Barrows [MVP]]

G wrote:

Hello Friend,

I have a doubt.
I am connecting to mysql db and there is only one table and i am
retrieving the data like city, state, county, etc.. from db to
comboboxes. so i am using one recordset for each retrivel and showing
into combobox. it is going slowly.

SO what happens if i use multiple recordsets in single ASP page?

So I think we can use only one recordset for all the data retrievel
from the db?

I would use a single disconnected recordset, using the Filter property
to get each subset of data.

--
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.