ASP login with access

[buchannon]

I'm trying to create a very simple logon using a number kids receieve at our school called the "bearnumber"

I found a sample ASP code to work with access and got everything working. I just had a few questions. If someone doesn't mind answering or pointing me in the direction of a good tutorial, that would be uber.

In this part of the script, what is going on?

strSQL = "SELECT * FROM tblLoginInfo " _
& "WHERE bearnumber='" & Replace(Request.Form("bearnumber"), "'", "''") & "';"

Set cnnLogin = Server.CreateObject("ADODB.Connection")
cnnLogin.Open("DRIVER={Microsoft Access Driver (*.mdb)};" _
& "DBQ=" & Server.MapPath("login.mdb"))

Set rstLogin = cnnLogin.Execute(strSQL)

If Not rstLogin.EOF Then

Also, in this line, what do all the ''',''' & ";" mean?

& "WHERE bearnumber='" & Replace(Request.Form("bearnumber"), "'", "''") & "';"

[sde]

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

[buchannon]

Ah thanks man, that helped a lot. I came across a simple SQL tutorial but couldn't figure out with that '_' was doing...

Another question:
I have 3 columns. One for fname (firstname), lname (last name), and bearnumber (the students bear number). If after that if statement it did find a matching bearnumber, how could I make the page display the first and last name associated with that bear number?

Thank you for the help sde!

[sde]

hmm .. not exactly sure .. i don't use asp much. check this link out, .. it will probably help.

http://www.w3schools.com/ado/ado_recordset.asp

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"

set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Customers", conn

for each x in rs.fields
   response.write(x.name)
   response.write(" = ")
   response.write(x.value)
next
%>

[buchannon]

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.

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