that looks like a handy attribute, although like you say James the SQL value doesn't look so easy straight forward to use once you use the CFQUERYPARAM on the ingoing query attribute. !?
:o/ On 9/18/06, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote: > James, > > In CFMX 7, there's an attribute called "result" for the <cfquery /> tag. > This will return a struct, that contains the executed SQL statement--along > with other miscellaneous information about the query. > > http://livedocs.macromedia.com/coldfusion/7/htmldocs/00000316.htm#1102316 > > -Dan > > >-----Original Message----- > >From: James Smith [mailto:[EMAIL PROTECTED] > >Sent: Monday, September 18, 2006 6:14 AM > >To: CF-Talk > >Subject: SQL in a variable > > > >Is there any way to get the formatted SQL from a query? For instance if I > >run the query... > > > >Select * from table where id = #someid# > > > >The debug info shows this as > > > >Select * from table where id = 7 > > > >Is there some way I can grab that second example from an existing variable > >or am I going to have to recreate it into a string? > > > >-- > >Jay > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4