พี่ๆครับช่วยดูหน่อยสิครับ แก้ตรงไหนผมทำไม่ได้สักทีเลยครับ Login มันชอบขึ้น Error แบบเนี๋ย
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/Projectmanagement/logcheck.asp, line 22
Private Sub LogResult(ByVal strPass,ByVal strUser,ByRef bnAdmin,ByRef gid,ByRef bAccess)
Dim Rs,Conn
bAccess = False
On Error Resume Next
Set Conn = Server.CreateObject("ADODB.Connection"):Conn.Open Application("strConn")
If Err.Number <> 0 Then Exit Sub
Set Rs = Conn.Execute("SELECT NAME,GID,IS_ADMIN FROM AUDITORS WHERE PASSWORD = '" & strPass & "'")
If Err.Number <> 0 Then Exit Sub
If Not(Rs.BOF AND Rs.EOF) Then
If Ucase(Rs("NAME")) = Ucase(strUser) Then
bAccess = True
bnAdmin = Rs("IS_ADMIN")
gid = Rs("GID")
Else
bAccess = False
End If
else
bAccess = False
bnAdmin = "N"
gid = "not found"
End If
Rs.Close
Conn.Close
If Not Rs Is Nothing Then Set Rs= Nothing
If Not Conn Is Nothing Then Set Conn = Nothing
แล้วก็เปลี่ยนจาก...
sql = "Select * From Filest Where (Idst = '"& user &"') And (Password = '"& pass &"')"
เป็น...
sql = "Select * From Filest Where (Idst='"& user &"') And (Password="& pass &")" <== ถ้าใน Access เป็นข้อมูลชนิด Number อ่ะครับ
<%
dim user,password
admin = "user"
pass= "password"
user = request.form("user")
password= request.form("password")
%>
<% if admin = user and pass = password then %>
<HTML>
<HEAD>
<TITLE> data </TITLE>
</HEAD>