CFQUERY sql string

[Scott*e]

Hi,

Is it possible to get hold of the sql string from a cfquery after it has
executed? Particularly, is it possible to get it even if debug is turned off?

I have a particularly difficult search page, with mutliple table being
included / excluded , and different group-bys depending on paramters.... and
now the users want to print the page using Crystal Reports. My thoughts are to
pass the query string to a stored procedure, and base the crystal report on it.

using cfmx 6.1

cheers,

[mxstu]

I haven't used this feature, but it is supposed to be possible in
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/[/url]
wwhelp.htm?context=ColdFusion_Documentation&file=0 0000316.htm

See :
result_name.sql
result_name.sqlparameters

[Scott*e]

HI,

I too have heard this.

However, I am using cfmx 6.1.

[mxstu]

In the earlier versions, the only option was to set store the sql string in a
variable like

<cfset sqlString = "SELECT Something FROM SomeTable">
<cfquery ...>
#sqlString#
</cfquery>

[url]http://cfdj.sys-con.com/read/41898.htm[/url] discusses a slight variation of that
method.

As far as I know, there isn't a way to do this with CFQUERY pre-MX 7, but I
haven't really looked into it since 4.x so don't take my word for it ;-)

[mxstu]

Check out the [url]http://www.cflib.org/udf.cfm?ID=686[/url] UDF at cflib.org

[Scott*e]

HI,

Thanks for continueing to think about it :-)