Re: DB_DataObjects Debugging: How do I get the raw sql string created by a dataobjects method?

On 4/19/06, Clements, Brent M (SAIC) <brent.clements@bp.com> wrote: > Only problem with that debugLevel method call is that it still doesn't output the actual > sql used. > Yes it does. Look at the docs. You have to set the debug level before doing your query. > > > > > This message may contain confidential and/or privileged information. If you are not the > addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take > any action based on this message or any information herein. If you have received this message in > error, please advise the sender immediately by reply e-mail and delete this message. Thank you for > your cooperation. > > ________________________________ > > From: Nicholas Costa [mailto:ncosta@alum.rpi.edu] > Sent: Wed 4/19/2006 1:38 PM > To: pear-general@lists.php.net > Subject: Re: [PEAR] DB_DataObjects Debugging: How do I get the raw sql string created by a > dataobjects method? > > > > Unfortunately, there is no direct way to retrieve the query created > and executed by DB_DO; this has been the subject of some frustration > to other developers on this list with regards to PEAR::DB, too. DO > has another interface for debugging that will be helpful, tho: > > DB_DataObject::debugLevel ( 5 ); > > By setting the debugging level to 5, DB_DO will output all queries > and responses, helping you to debug. The function is documented here: > > http://pear.php.net/manual/en/package.database.db-dataobject.db- > dataobject.debuglevel.php . > > HTH, > Nick > > On Apr 19, 2006, at 2:31 PM, Clements, Brent M ((SAIC)) wrote: > > > In debugging my dataobjects based app, I'd like to see the sql that > > is created and executed by Dataobjects, how do I get that sql string? > > > > Thanks, > > BC > > > > > > > > This message may contain confidential and/or privileged > > information. If you are not the addressee or authorized to receive > > this for the addressee, you must not use, copy, disclose, or take > > any action based on this message or any information herein. If you > > have received this message in error, please advise the sender > > immediately by reply e-mail and delete this message. Thank you for > > your cooperation. > > > > -- > > PEAR General Mailing List (http://pear.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PEAR General Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PEAR General Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Justin Patrin