> Second, I don't think you'll be able to effectively use CFQUERYPARAM within > CFSAVECONTENT. CFQUERYPARAM builds a prepared statement, which separates the > values within an SQL statement from the actual SQL statement itself. So, > where the CFQUERYPARAM tag now sits, you'd see a question mark in the actual > SQL statement.
OK so instead of calling <cfqueryparam> call cf_queryparam> where queryparam.cfm looks like this (you could do something much more elegant if you wanted) <cfparam name="attributes.value" default=""> <cfparam name="attributes.cfsqltype" default=""> <cfparam name="attributes.maxlength" default=""> <cfparam name="attributes.null" default=""> <cfqueryparam value="#attributes.value#" cfsqltype="#attributes.cfsqltype#" maxlength="#attributes.maxlength#" null="#attributes.null#"> <cfset caller.params = caller.params & attributes.value & "<br>"> Of course you'd need to set params to "" before the query, and output it after the query. Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
