Vilken databas? mySQL? SQL server? Access?
I MySQL kan man ställa in direkt i databasen om den ska vara case sensitive eller inte, dom övriga vet jag faktiskt inte! Så kolla över databas inställningarna!
Mitt inloggningsscript är inte Case sensetive, vad kan detta bero på månne?
Lite kod:
<%
Option Explicit
Dim sql,rsUser,username,password,page,stayloggedin,LConnectString,lconn,rsProfile,lastlogg
username = Request.Form("username")
password = Request.Form("password")
page = Request.Form("page")
stayloggedin = Request.Form("stayloggedin")
lastlogg = Request.Form("lastlogg")
<!--#include virtual="/conn.asp"-->
sql = "SELECT username FROM users WHERE username = '" & username & "' AND password = '" & password & "'"
Set rsUser = Server.CreateObject("ADODB.Recordset")
rsUser.Open sql, conn, 3, 3
'If there was a valid recordset there, then send them back to the page they came from, with the username cookie set
If (not rsUser.BOF) and (not rsUser.EOF) then
Response.kaka("username") = rsUser("username")
if stayloggedin = "true" then
Response.kaka("username").expires = date() + 365
end if
Set rsUser = Server.CreateObject("ADODB.Recordset")
rsUser.open "users WHERE username = '" & username & "'", conn, 3, 3
rsUser("lastlogg") = lastlogg
rsUser.Update
rsUser.close
set rsUser = nothing
conn.close
set conn = nothing
Response.Redirect(page)
end if
rsUser.close
set rsUser = nothing
conn.close
set conn = nothing%>

