|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
