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