Re: small dooubt on recordset

Store recordsets as array using function GetRows of recordset object.

This will be pretty faster.

HTH

Raj.
"G" wrote in message
news:ulQCMKrdHHA.4964@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
>

small dooubt on recordset

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

Re: small dooubt on recordset

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.