Hello, Steve Onnis wrote: > Just looking at getting thoughts back before i post it ias a feature > rest. > > The number of times you need to debug a query because it not giving you > what you expect, and especially within CFCs, wouldnt it be nice to have > an additional value containing the actual query text of the query that > was performed. Something like query.sqlStatement or something. >
It there, if a little indirectly if you are on MX7. There is a parameter called "result" which you can add to the <cfquery tag. With it you can specify the name of a result structure and then the <cfquery returns a bunch of results, including the actual SQL statement. For reference: http://www.cfquickdocs.com/?sourceid=cfQDSearch1.02&getDoc=cfquery HTH Kym K --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---