thanks, chris. actually, i was trying to view just the select portion before the query ran. anyway, i ended up just using the getLastExecutedQuery() method of the gateway object. thanks all the same. B.
--- Chris Phillips <[EMAIL PROTECTED]> wrote: > ColdFusion's debugging (if turned on and configured > correctly) will show you > all the sql statements that it runs. > Don't foget to turn off "report execution times". > > On 12/25/06, bayo <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I'm trying to view the select portion of a query > by rendering it using > > > > > queryObject.renderSelect(queryObject,conventionObject) > > > > This is my first time trying this, and I've run > into a problem - > > > > The Reactor component query.render.Query (line > 161) tries to execute > > query.getWhere().getWhere() and throws an error. > Apparently, the where > > object returned by query.getWhere() does not have > a getWhere() method, > > only a getWhereCommands() method. > > > > Am I missing something here? Is there another way > to see the actual SQL > > produced by a query object? > > > > Thanks. > > > > Bayo > > > > > > > > > > > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- > > -- -- > > Reactor for ColdFusion Mailing List > > [email protected] > > Archives at: > http://www.mail-archive.com/reactor%40doughughes.net/ > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- > > -- -- > > > > > > > -- > Chris Phillips > www.dealerpeak.com > Senior Application Developer > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- -- -- > Reactor for ColdFusion Mailing List > [email protected] > Archives at: > http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
