Ask a Question related to Dreamweaver AppDev, Design and Development.
-
mbwete #1
Registration Page
Hi all,
Im doing a registration page for site visitors but I cant connect the
registration page and the databse. I have a primary key in the registration
table which is an auto number. Could that be a problem? Attached is the code,
please help.
Thanks,
Grace
ASP connection code:
<% @LANGUAGE = VBScript%>
<HTML>
<HEAD>
<TITLE>Database Connection</TITLE>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1"></HEAD>
<BODY>
<%
Dim objConn, strConn, regStatement
Set objConn= Server.CreateObject("ADODB.Connection")
strConn = "Provider = Microsoft.Jet.OLEDB.4.0; Data
Source=C:\web\pelahet.mdb;"
objConn.Open strConn
regStatement="INSERT INTO Customers ('" & Request("CompanyName") & "','" &
Request("Title") & "','" & Request("FirstName") & "','" & Request("LastName") &
"','" & Request("CustomerEmail") & "','" & Request("BillingAddress1") & "','" &
Request("BillingAddress2") & "','" & Request("BillingCity") & "','" &
Request("BillingCounty") & "','" & Request("BillingPostalCode") & "','" &
Request("BillingCountry") & "','" & Request("Phone") & "','" & Request("Fax") &
"','" & Request("SameDelivery") & "', '"& Request("DeliveryAddress1") & "', '"
& Request("DeliveryAddress2") & "', '"& Request("ShipCity") & "', '"&
Request("ShipCounty") & "', '"& Request("ShipPostalCode") & "', '"&
Request("ShipCountry") & "', '"& Request("Password") & "', '"&
Request("Confirm") & "')"
objConn.Execute regStatement
objConn.close
Set objRS = Nothing
Response.Redirect("/RegResult.asp")
%>
</BODY>
</HTML>
Registion file
mbwete Guest
-
Creating a Login / Registration Page
Can someone please direct me to an article, website or any other data which will help me with this topic: I have a family website and my wife... -
code for basic registration to secure page
hello there I know that this already exists, I just need to find the snippet or formated codes and where they are located. thanks -
PHP/MySQL Registration Page
I have created a registration page that checks for a unique username before submitting the users info. If a username is found an error it thrown,... -
Registration page into database
Hi all, Im doing a registration page for site visitors but I cant connect the registration page and the databse. I have a primary key in the... -
Forms autentication and registration page - some advices
Hi, I implement forms authentication in my application. So I have a login form. Actually I have two custom Web controls, one to login and one to... -
Paul Whitham TMM #2 Re: Registration Page
The autonumber primary key is a very common occurance, and so this should
not be the problem. Are you getting any specific errors?
--
Regards
Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]
Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]
"mbwete" <webforumsuser@macromedia.com> wrote in message
news:d30v87$dcv$1@forums.macromedia.com...registration> Hi all,
> Im doing a registration page for site visitors but I cant connect the
> registration page and the databse. I have a primary key in thecode,> table which is an auto number. Could that be a problem? Attached is the&> please help.
>
> Thanks,
> Grace
>
> ASP connection code:
> <% @LANGUAGE = VBScript%>
> <HTML>
> <HEAD>
> <TITLE>Database Connection</TITLE>
> <meta http-equiv="Content-Type" content="text/html;
> charset=iso-8859-1"></HEAD>
>
> <BODY>
> <%
> Dim objConn, strConn, regStatement
>
> Set objConn= Server.CreateObject("ADODB.Connection")
> strConn = "Provider = Microsoft.Jet.OLEDB.4.0; Data
> Source=C:\web\pelahet.mdb;"
>
>
> objConn.Open strConn
>
> regStatement="INSERT INTO Customers ('" & Request("CompanyName") & "','"Request("LastName") &> Request("Title") & "','" & Request("FirstName") & "','" &"','" &> "','" & Request("CustomerEmail") & "','" & Request("BillingAddress1") &Request("Fax") &> Request("BillingAddress2") & "','" & Request("BillingCity") & "','" &
> Request("BillingCounty") & "','" & Request("BillingPostalCode") & "','" &
> Request("BillingCountry") & "','" & Request("Phone") & "','" &"', '"> "','" & Request("SameDelivery") & "', '"& Request("DeliveryAddress1") &> & Request("DeliveryAddress2") & "', '"& Request("ShipCity") & "', '"&
> Request("ShipCounty") & "', '"& Request("ShipPostalCode") & "', '"&
> Request("ShipCountry") & "', '"& Request("Password") & "', '"&
> Request("Confirm") & "')"
>
> objConn.Execute regStatement
>
>
> objConn.close
>
>
> Set objRS = Nothing
>
> Response.Redirect("/RegResult.asp")
> %>
> </BODY>
>
> </HTML>
>
> Registion file
>
Paul Whitham TMM Guest
-
mbwete #3 Re: Registration Page
Yes, the error says
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement
I have checked my insert statement , tried to correct it to no avail.
Please help.
Thanks,
Grace
mbwete Guest
-
Paul Whitham TMM #4 Re: Registration Page
Check two things
1) you have not used any reserved words (such as name, desc, date, password)
in naming your fields.
2) you are not trying to insert a string value into a numeric field. The
most common problem is $ signs or commas in number fields.
--
Regards
Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]
Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]
"mbwete" <webforumsuser@macromedia.com> wrote in message
news:d32s8t$593$1@forums.macromedia.com...> Yes, the error says
> Error Type:
> Microsoft JET Database Engine (0x80040E14)
> Syntax error in INSERT INTO statement
>
> I have checked my insert statement , tried to correct it to no avail.
> Please help.
>
> Thanks,
> Grace
>
Paul Whitham TMM Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
