RE: [PEAR] DB_DataObjects Debugging: How do I get the raw sql string created by a dataobjects method?
| From: | Clements, Brent M \(SAIC\) | Date: | Wed, 19 Apr 2006 18:41:59 +0000 |
| Subject: | RE: [PEAR] DB_DataObjects Debugging: How do I get the raw sql string created by a dataobjects method? | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-23755@lists.php.net to get a copy of this message | ||
Only problem with that debugLevel method call is that it still doesn't output the actual sql
used.
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