| | |
| |
Active Server Pages ASP a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. 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 |
|
|
|
|
|
|
