I think you need to use createODBCDate() around your date. The pounds that you used, like other a lot of other syntax that you can use directly within Access, *do not* work in _odbc_.
Thanks, Jamie On Thu, 17 Jul 2003 11:59:44 -0400, in cf-talk you wrote: >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
