Dynamic Select Case

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Dynamic Select Case

Logged in as: Guest

arrSession:exec spGetSession 2,3,52881

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Dynamic Select Case
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Dynamic Select Case - 10/21/2007 11:46:37 PM

JBarbea1

Posts: 20
Score: 0
Joined: 3/27/2007
Status: offline

Im having some trouble with a Dynamic Select Case Statement.

Has anyone ever tried this before? The code I have keeps failing, I have a While Statement inside a Select Case, and recently was told that it is not allowed. Any ideas?

Background:

I have 2 recordsets, the first recordset has an foreign key ID #, the second recordset has the primary key and information and I want to make a select case statement dynamic from the second recordset.

sorta like this:

Select Case strInstructorID
While Not rs.EOF

Case (rs.fields.items("id").Value
Reponse.Write(rs.Fields.Item("First_Name")Value)

rs.MoveNext
Wend

End Select