| | |
| |
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: |
Syntax error in insert into statement |
|
From: |
alfonso |
|
Date: |
7/26/1999 4:42:07 PM |
|
IP: |
209.214.17.20 |
Hi
I have intalled a message board very much like this one in my web site. Every thing works fine but the module to peply to a message. I get the following:
Microsoft OLE DB Provider for ODBC Drivers error 80040e14
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/forums/addnew.asp, line 66
And this are the lines of code that generate the problem:
Application.Lock
sSQL = "INSERT INTO Message ( From, Email, Subject, Body, When, MsgLevel, PrevRef, ThreadPos, GroupName, Host ) " _
& "VALUES (" & strFrom & ", " & strEmail & ", " & strSubject _
& ", " & strBody &", " & CStr(Now()) & ", " & intNewMsgLevel _
& ", " & lngPrevRef & ", " & intNewThreadPos & ", " & strGroup & ", " &strHost &");"
Response.Write sSQL
db.Execute(sSQL)
Can any one help me?
Alfonso |
|
|
|
|
|
|
