susan
9/19/2008
00:39:17
|
ASP
Hi Friends!
I am new for ASP. So pls any one help me...
IN login page, i have 2 text boxs.
1. Username -- username is name of the user(susan)
2. Password -- Password is Date of Birth (12/08/91)
I want to check the data in to the database. How?
Below is my coding: (Pls any one help me....)
<%pathdefiner = "../"%>
[an error occurred while processing this directive]
<%
dim uname
dim pwd
uname = Request.Form("txtUname")
uname = UCASE(uname)
Session.Contents("IDNO") = uname
Session.Timeout = 30
pwd = Request.Form("txtPwd")
Set rs = Server.CreateObject("ADODB.Recordset")
Set rs.ActiveConnection = my_Conn
rs.Open "SELECT * FROM " & TBL_Data &" where "& TFL_IDNO & " = '" & Session.Contents("IDNO") & "'", my_Conn, 1
if rs.RecordCount = 0 then
rs.Close
my_Conn.Close
set rs=nothing
set my_Conn=nothing
Response.Redirect("verify.asp?Submit=namefailed")
end if
if rs("DOB")= pwd then
rs.Close
my_Conn.Close
set rs=nothing
set my_Conn=nothing
Response.Redirect("verifyParticulars.asp")
else
rs.Close
my_Conn.Close
set rs=nothing
set my_Conn=nothing
Response.Redirect("verify.asp?Submit=passfailed")
end if
%>
|
|
|
susan
9/19/2008
01:23:02
| ASP
Pls any one help me.... (shivasusan@yahoo.com)
<%pathdefiner = "../"%>
[an error occurred while processing this directive]
<%
dim uname
dim pwd
uname = Request.Form("txtUname")
uname = UCASE(uname)
Session.Contents("IDNO") = uname
Session.Timeout = 30
pwd = Request.Form("txtPwd")
Set rs = Server.CreateObject("ADODB.Recordset")
Set rs.ActiveConnection = my_Conn
rs.Open "SELECT * FROM " & TBL_Data &" where "& TFL_IDNO & " = '" & Session.Contents("IDNO") & "'", my_Conn, 1
if rs.RecordCount = 0 then
rs.Close
my_Conn.Close
set rs=nothing
set my_Conn=nothing
Response.Redirect("verify.asp?Submit=namefailed")
end if
if rs("DOB")= pwd then
rs.Close
my_Conn.Close
set rs=nothing
set my_Conn=nothing
Response.Redirect("verifyParticulars.asp")
else
rs.Close
my_Conn.Close
set rs=nothing
set my_Conn=nothing
Response.Redirect("verify.asp?Submit=passfailed")
end if
%>
|
Eric
9/19/2008
02:08:16
| RE: ASP
Hi Susan,
Try removing parts of your code until you get it to run without a runtime error. Then gradually add more code until you get the error. That way you will have an idea of where the error lies.
Eric |
|
|
