Using cfqueryparm to update table with values coming from a standard form via a CFC, using the cfargumentcollection="#form#"
In the form, I use HTMLEditFormat for fields where could be an apostrophe, etc. so sql insert or update goes ok. This has always worked as expected with simply inserting/updating table by field = '#field#' or using cfqueryparm: showTitle = <cfqueryparam cfsqltype="cf_sql_varchar" value="#showTitle#" />, Decided to add a trim to the field in the update, as in: showLabel = <cfqueryparam cfsqltype="cf_sql_varchar" value="#trim(showLabel)#" />, No errors or anything, but if there is an apostrophe in the field value, it inserts an additional apostrophe, so ' becomes ''. If update again, the '' becomes '''. If I take off the trim function in the cfqueryparm value, the apostrophe inserts/updates properly. I want to use the cfqueryparm, so just chucked the trim function. Just seems strange that trim would make this difference. I'd assume there's an explanation? Here are key parts of code: The input form: <input type="text" name="showTitle" value="#HTMLEditFormat(stShowSetUp.showTitle)#" size="60" maxlength="150"> Processing template: <cfinvoke component="galleryCfc" method="updateShow" argumentcollection="#form#" returnvariable="Updated"> <cfinvokeargument name="DS" value="#request.datasource#" /> <cfinvokeargument name="showID" value="#existShowID#" /> </cfinvoke> In the CFC: (query) Set showTitle = <cfqueryparam cfsqltype="cf_sql_varchar" value="#showTitle#" />, etc updates Thanks for any insight! E. Keith Dodd Wings of Eagles Services [EMAIL PROTECTED] - [This E-mail scanned for viruses by declude AntiVirus Software] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
