hi there..

when you said top and bottom lines you refers to the recordset?? cause it's has eof for the last record and bof for the first one (the two of them are null)...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========

hi

what i mean is, for that piece of code it says "No match found, EOF is not true" and then "EOF is true, no match found"

How can EOF be true and false when no match is found? Surely that is an error?

neil

It can't. That piece of code is not in a loop so, as such, either the If statement or the else statement will execute. If the recordset is not EOF then the if portion will be evaluate if the recordset is EOF then the else statement will be evaluated. Execution inside the if does not fall through to the else statement.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

somebody makes a mistake there.. eof is true when no match is found...

and if you are getting always invalid password is because you are doing probably the wrong query..

for what i read you are programming in a notepad..

Doug any idea how he can trace the code?? maybe instead of write invalid password show the data you are searching for???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========

Hi,

The code used is on the first page - all i did to tweak it was change the table name and the mdb file path. otherwise, the code is as it is on page 1. even if a write or response was used, why is it that there is an invalid password response every time? i have looked at the code and im definate that it references the right tables and cells within.

Neil

Oh god, how I wish tracing was available in Classic >< Sadly, no, no tracing is available to you. I would suggest doing: Response.Write(sql) does this show the correct SQL Statement? Better yet if you execute it in Access does it return anything?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

sorry, not sure what you are asking for once i change the statement

neil

Replace this line:
set rec=Con.execute(sql)

with
Response.Write(sql)

This will write out the sqlStatement you are passing into Access. Is it the statement you expect to be sending in?

Also consider changing this:
  Dim Con, sql, rec
   set Con = Server.CreateObject("ADODB.Connection")
  Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")
'Select the record matching the username.
   sql = "SELECT * FROM tblusers WHERE UCase(username)=' "& UCase(username) & "' AND UCase(password)=' " & UCase(password) & " ' "
   set rec=Con.execute(sql)
   'If no match found, EOF is not true.
   if NOT rec.EOF then
      Response.Redirect("somepage.asp") 'Change to page redirect to after login
   else
      blankError="Invalid username." 'EOF is true, no match found.
   end if

To this
If username <> "" and password <> "" then
  Dim Con, sql, rec
   set Con = Server.CreateObject("ADODB.Connection")
  Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")
'Select the record matching the username.
   sql = "SELECT * FROM tblusers WHERE UCase(username)=' "& UCase(username) & "' AND UCase(password)=' " & UCase(password) & " ' "
   set rec=Con.execute(sql)
   'If no match found, EOF is not true.
   if NOT rec.EOF then
      Response.Redirect("somepage.asp") 'Change to page redirect to after login
   else
      blankError="Invalid username." 'EOF is true, no match found.
   end if
end if

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Hi,

I will try that now, thanks.

How can i read how the sql statement is accessing the database?

Neil

Response.Write(sql)

That will show you your sql statement.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html