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/

Reply via email to