that's it, that's gotta be it ben....well done! 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: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 12:11 PM To: CF-Talk Subject: RE: Invalid SQL statement Shouldn't it be #preservesinglequotes(featuresql)# ?? -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -----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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
