thanx Paul, that IS a smarter way to write it - except that I *always* use cfqueryparam...
rats! cheers barry.b -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 1 September 2004 12:59 PM To: CFAussie Mailing List Subject: [cfaussie] Re: capturing the executed query? On Wed, Sep 01, 2004 at 12:33:47PM +1000, Barry Beattie wrote: > Below is a really clunky way I'm doing it at the moment. it *does* give > me what I want BUT > 1) it's high maintainance (change the SQL and change the > debugging.content manually - yuck) > 2) any cfqueryparams don't get parsed into it so they have to be > stripped back to plain variables I don't have an answer for the cfqueryparams problem, but I can suggest you try <cfquery ... > <cfsavecontent variable="blah"> select a,b,c from table where foo = <cfqueryparam... > </cfsavecontent> #blah# </cfquery> I tested this with a simple query and it both populated the variable with the query (sans queryParams) and ran the query correctly. Cheers Paul Haddon Technical Services Manager Formstar Print Technologies --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
