The only way I've done that before is to do something like:
<CFSaveContent variable="a">
Select * from blah
</CFSaveContent>
<CFQuery ...>
Select * from blah
</CFQuery>
Basically writing the query twice. It kinda sucks, but that's the only
way I've thought of. Also, if your real sql contains cfqueryparams, then
you have to get rid of those in the version that goes to the log file.
If anyones got a better idea, I'd like to hear it too. :o)
Cheers,
Chris
Richard Colman wrote:
> I wish to store the actual text of a SQL query to a logfile.
>
> At the risk of belaboring the obvious, from:
>
> <cfquery ...>
> Select * from blah
> </cfquery>
>
> I wish to actual put "select * from blah" into a text variable and write
> it to a logfile or data table.
>
> Can someone suggest an easy way to do this?
>
> TNX.
>
> Rick Colman
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267186
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
