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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
