I would say it's the extra #'s on the date? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337
-----Original Message----- From: Tim Kutchen [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 12:00 PM To: CF-Talk Subject: Invalid SQL statement The error: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE' The code: <cfset FeatureSql="INSERT INTO Feature (theDate, Title, teaser, issue, Author, PhotoNumber) VALUES (###form.date###, '#form.title#', '#form.cover#', #form.issue#, '#form.author#', #FeatureImage#);"> <cflock name="InsertNewRelease" type="exclusive" timeout="30"> <cftransaction> <cfquery name="InsertFeature" datasource="Anishinaabe"> PreserveSingleQuotes(#FeatureSql#) </cfquery> </cftransaction> </cflock> <cfoutput> writes out: INSERT INTO Feature (theDate, Title, teaser, issue, Author, PhotoNumber) VALUES (#03/03/2003#, 'The Title', 'teaser', 1, 'The Author', 12); Works fine when executed in Access 2002 interface. Running CF MX Server on IIS 5.0. Any ideas? Thanks, -tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
