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/
