How can I save cfquery sql text, not the results

Hi,

I have the need to save a dynamically generated cfquery actual sql, not the results.

I can see it in <cfdump var="#<qry_name>#"> but, how can I capture the actual sql

and save it in a var for later use ?

Thanks,

Bob

This topic has been closed for replies.

Correct answer ilssac

The results property of the <cfquery....> tag allows you to put that information into a variable for later use.

I.E.

<cfquery ... results="stuff">...</cfquery>
<cfdump var="#stuff#">

Participating Frequently


....



]]>

Mack

ilssacCorrect answer

Inspiring

The results property of the <cfquery....> tag allows you to put that information into a variable for later use.

I.E.

<cfquery ... results="stuff">...</cfquery>
<cfdump var="#stuff#">

Inspiring

Thanks, but I do not want the Results, I want the SQL.

Inspiring

Oh, I see, it actualy does put the sql in the structure. Thanks, that will do it !!

Sign up