This message was edited by Iggy at 2004-4-10 3:55:10
I'm having problems updating an Access databse with this code:
<FORM METHOD = POST ACTION = "RegisterValidation.asp">
UserName : <INPUT TYPE = "text" Size = "10" Name = "UserName">
Full Customer Name: <INPUT TYPE = "text" Size = "10" Name = "CustomerName">
Password : <INPUT TYPE = "text" Size = "10" Name = "Password">
Address : <INPUT TYPE = "text" Size = "20" Name = "Address">
Town : <INPUT TYPE = "text" Size = "20" Name = "Town">
Post Code : <INPUT TYPE = "text" Size = "10" Name = "PostCode">
Tel No : <INPUT TYPE = "number" Size = "10" Name = "TeleNumber">
E-Mail : <INPUT TYPE = "text" Size = "20" Name = "Email">
<INPUT TYPE = "submit" Value = "Enter">
Which links to this:
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & _
Server.MapPath("\eggyharold\db\CTC.mdb")
SQL ="INSERT INTO CUSTOMERS (UserName, CustomerName, Password, Address, Town, PostCode, TeleNumber, Email) values "
SQL = SQL & "('"
SQL = SQL & Request.Form("UserName") & "','"
SQL = SQL & Request.Form("CustomerName") & "','"
SQL = SQL & Request.Form("Password") & "','"
SQL = SQL & Request.Form("Address") & "','"
SQL = SQL & Request.Form("Town") & "','"
SQL = SQL & Request.Form("PostCode") & "','"
SQL = SQL & Request.Form("TeleNumber") & "','"
SQL = SQL & Request.Form("Email") & "');"
MyConn.Execute SQL
%>
I can't see what the error is. I'm new to ASP and SQL, and don't have access to IIS so I'm not getting error messages, just page not found web errors.
