|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
