Thanks for the responses. I'm going to have to take some time to digest this for a little while. I've been out of the CFML for a few months.
Macromedia Suggestion? Is there a reason why the content found between the <cfquery> and </cfquery> tags is not available in a structure variable like query_Name.RecordCount, query_name.CurrentRow and query_name.ColumnList. How is this content provided when I set the DEBUG mode on in the ColdFusion Administrator Configuration pages? Sincerely, Troy Matthew Walker wrote: > > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
