|
1220a -> html form to acess database via asp (5/21/2004 19:54:14)
|
pls help:
code in question:
<%
Dim FirstName, LastName, Company, Telephone, Email, Business, Service, Pages, Length, Message
Dim Conn
Dim SQL
If request("insrow") = "1" THEN
FirstName = request("FirstName")
LastName = request("LastName")
Company = request("Company")
Telephone = request("Telephone")
Email = request("Email")
Business = request("Business")
Service = request("Service")
Pages = request("Pages")
Length = request("Length")
Message = request("Message")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("<%
Dim FirstName, LastName, Company, Telephone, Email, Business, Service, Pages, Length, Message
Dim Conn
Dim SQL
SQL = "INSERT INTO tblQuote (FirstName, LastName, Company, Telephone, Email, Business, Services, Pages, Length, Message) VALUES(" & FirstName & ", " & LastName & ", '" & Company & "', " & Telephone & ", " & Email & ", " & Business & ", " & Service & ", " & Pages & ", " & Length & ", " & Message & ")"
'Response.Write("SQL statement is " & SQL)
'Response.End()
Conn.Execute (SQL)
Conn.Close
Set Conn = Nothing
response.write("<p>Your message has been sent!</p>")
End If
%>"
returns:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/_contact/thankyou.asp, line 193
here is the statement:
INSERT INTO tblQuote (FirstName, LastName, Company, Telephone, Email, Business, Services, Pages, Length, Message) VALUES(s, s, s, s, s, s, , , , )
I could use some help
pls
thx in advance
|
|
|
|
