Ok I can get it to display only the line of the table I want, but now I can't figure out how to edit out one of the variables. I want it to display 'Welcome (fname) (lname)' but right now it is naming all three variables: (fname) (lname) and (bearnumber)
I was thinking of putting a counter in the loop but it's not working.
Quote:
dim counter
counter = 0
response.write("<center>Welcome ")
do until rs.EOF
for each x in rs.Fields
Response.Write(x.value & " ")
counter = counter + 1
if counter = 2 then stop
next
|