Speaking out of ignorance, but why not just store and pass the SQL as a variable? Many of my queries look like:
<cfquery> #MyQueryString# </cfquery> This may not be best practice, though, look forward toi being corrected. Chad who will admit to watching "Annie" with his kid this weekend. On 7/18/05, Scott Thornton <[EMAIL PROTECTED]> wrote: > Hi, > > Is it possible to get hold of the sql string from a cfquery after it has > executed? Particualrly, 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, > > > Scott Thornton, Programmer > Application Development > Information Services and Telecommunications > Hunter-New England Area Health Service > Phone RNH +61 2 49236078 > Fax +61 2 49236076 > > [EMAIL PROTECTED] > > > --- > 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/ > --- 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/
