View Single Post
Old 11-17-2004, 12:50 PM   #2 (permalink)
sde
Moderator
 
sde's Avatar
 
Join Date: May 2002
Location: us.ca
Posts: 4,446
sde is on a distinguished road
asp is a little different to the c style syntax (javascript,php,c,c++,java,perl) trained people.

asp ends a line of code with a new line. if you want your line of code to keep going, then you use the '_' at the end of the line.

'&' is used as a concatinator. the equivalent to '+' in javascript, or '.' in php.

that code is createing a sql string: select * from tblLoginIfno where bearnumber='<bearnumber-sent-from-form>'

the next line create the connection to the database, login.mdb

Set rstLogin = cnnLogin.Execute(strSQL) <-- this line executes the query to the database.

the last line is just saying .. "do this if there is a result" or more accurately, "if we are not at the end of the rstLogin record set, then do this .."

hth
__________________
Mike
sde is offline   Reply With Quote