I have a select statement that narr

[skispray]

I have a select statement that narrows the records down to one (ex. A UserID). Something that I want out of that row is to set the variable strFirstName to the value in the "FirstName" column in my record. How do I do that?

 

[Isadore]

skis: I would select "FirstName" in the SELECT statement and then pick up the value when you execute your reader; one possibility..e.g.,

SELECT ..., ..., "FirstName" FROM tbl...

and when you execute the reader pick up the value:

Dim strFirstName As String
reader = DBCommand.ExecuteReader()
While reader.Read()
....
strFirstName = reader("FirstName&quot
Acme.Text = reader("Acme&quot
...
End While
reader.Close()

...just a thought.