Hey friends, i require a solution.
i require to generate recordset dynamically, in one of my application.
for example:

<%

For i=1 to 5
  objRs = "Rs" & i
  Set objRs = Server.CreateObject("ADODB.Recordset")
   ..........
   .........
   code using recordset.
  Set objRs = Nothing
Next
%>

How can this be possible ?
I dont want to create 5 different ADO Recordset.

Please Help me out friends..

Hey Pravin,

I think I have something for you, if I understand your problem right. The Execute statement. Check it out at:

http://msdn.microsoft.com/library/de...1136f2df81.asp

For i=1 to 5
   str = "Set objRs" & i & " = Server.CreateObject(" & chr(34) & "ADODB.Recordset" & chr(34) & ")"

   Execute str

....

This will create objRs1 through objRs5.

Not sure why you would want to do something like this, but in any case I think your question was about assigning to a variable name created dynamically.

Cheers,

Joel

;;Not sure why you would want to do something like this
I can think of a reason or two (a heirachial menu, generating bar graphs on the fly)

;;I think your question was about assigning to a variable name created dynamically.
Yes, this is how I read it also.

mmmmmmm I have tryed to dynamicly name a record set and failed. I dont believe its possible with classic ASP. The post is here somwhere I will try and find it for you. There was allot of input from senior members, a solution was not found. i am very interested in seeing some code that works if anybody has managed to do it.

Wind is your friend
Matt

Ok I found it:

http://p2p.wrox.com/topic.asp?TOPIC_...ecord,set,name

FYI: This post has had input from the most senior and IMO Mr ASP

BTW: Next time you have a problem try and search for it on the forum before posting, there is a good chance the question has been asked and answered (like this one) This is why its important to logically name your posts. if you search for 'dynamicly name a record set' you would have found it

HTH

Wind is your friend
Matt