You need single quotes around all "char" data... as in '#form.subject#'. You will need to correctly format the date as
well. Try using #createodbcdate(form.thisdate)# for that item. Also - as has been suggested a couple of times - using
CFQUERYPARAM would be a good idea - faster, and safer - like the promise of mass rail transit.
-Mark
-----Original Message-----
From: Steven Sharko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 8:38 AM
To: CF-Talk
Subject: still having a problem with insert
Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error in INSERT INTO statement.
The error occurred in D:\websites\serviceorders.cfm: line 127
125 : insert into clntnote (thisdate,subject,note,type,compid)
126 : values
(#form.thisdate#,#form.subject#,#form.note#,#form.type#,#form.compid#)
127 : </cfquery>
128 : </CFIF>
129 : <CFIF ParameterExists(sta) eq 'true'>
SQL insert into clntnote (thisdate,subject,note,type,compid) values ({ts
'2004-02-25 09:36:45'},Service Ticket 3172 - ,<br>Submitted by ,t,)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
