Dynamic Select Case

Author Message
JBarbea1

  • Total Posts : 20
  • Scores: 0
  • Reward points : 0
  • Joined: 3/27/2007
  • Status: offline
Dynamic Select Case Monday, October 22, 2007 12:46 AM (permalink)
0
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

 
#1

    Online Bookmarks Sharing: Share/Bookmark

    Jump to:

    Current active users

    There are 0 members and 1 guests.

    Icon Legend and Permission

    • New Messages
    • No New Messages
    • Hot Topic w/ New Messages
    • Hot Topic w/o New Messages
    • Locked w/ New Messages
    • Locked w/o New Messages
    • Read Message
    • Post New Thread
    • Reply to message
    • Post New Poll
    • Submit Vote
    • Post reward post
    • Delete my own posts
    • Delete my own threads
    • Rate post

    2000-2012 ASPPlayground.NET Forum Version 3.9