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
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
