i need help..
i can bring the values of the input over but i cannot store them in the database...why?
This is the code.
Code:
<%
Response.ContentType="text/vnd.wap.wml"
Dim adm_no, pass_no
adm_no=Request("Admission")
pass_no=Request("Password")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("databid.mdb"))
sql="INSERT INTO register (Userid,Pass)"
sql=sql & " VALUES "
sql=sql &"('" & adm_no &"',"
sql=sql &"'" & pass_no &"')"
%>
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.3//EN"
"http://www.wapforum.org/DTD/wml13.dtd">
<wml>
<card id="card3" title="ASP3">
<p>
Your id is:
<br/>
<%Response.Write(adm_no)%>
<br/>
Your pass is
<br/>
<%Response.Write(pass_no)%>
<do type="accept" label="Back">
<prev />
</do>
</p>
</card>
</wml>
<%
conn.close
%>