|
|
|
|
|
| | |
| |
Active Server Pages asp search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Help me with this code... |
|
From: |
Joseph A Velazquez |
|
Date: |
5/7/2003 11:59:50 PM |
|
IP: |
66.81.19.53 |
Ack! I am having so much trouble with this code! It may be cause I am an amatuer ASP programer but please help! I am testing out a news system for my friends' site. When I tested the posting page, I got an error saying
"Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement."
Here is Line 25 which I am having problems with. I have added the surrounding lines which may be the problem.
<%
Dim objRS, bolAlreadyExists
If ((Request.Form("name") = "") OR (Request.Form("date") = "") _
OR (Request.Form("title") = "") OR _
(Request.Form("content") = "")) Then
Response.Write "<A HREF='post.asp'>"
Response.Write "You must enter values for all the fields."
Response.Write "</A>"
Else
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "news", objConn, , adLockOptimistic, adCmdTable
objRS.AddNew
objRS("name") = Request.Form("name")
objRS("date") = Request.Form("date")
objRS("title") = Request.Form("title")
objRS("content") = Request.Form("content")
objRS.Update
End If
%>
I am using a DSN connection and connected it to the page and adovbs.inc also. Please help me out! |
Follow Up - Re: Help me with this code... - Bullschmidt 5/21/2003 11:51:29 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
