connection string ?

  • Thread starter Thread starter CarpetMnuncher!
  • Start date Start date
C

CarpetMnuncher!

What's wrong with this?

Set Con = Server.CreateObject("ADODB.Connection")
Con.Open strCon
sql = "Select uName, pword from settings WHERE uname = '"&
session("site_username") & "' AND pword = '"& session("site_password") & "'"
set rec = Con.execute(sql)
if rec.eof then
response.redirect "login.asp"
end if


rec.close
set rec = nothing
Con.close
set Con = nothing
 
Can't see anything obviously wrong. What happens when the code runs? Are you
getting an error message?
 
Back
Top