For future reference, the easiest way (in postDispatch()) was:
$dbAdapter = Zend_Registry::get( 'dbAdapter' );
$profiler = $dbAdapter->getProfiler( );
$query = $profiler->getLastQueryProfile( );
echo $query->getQuery( );
- Brian
Jon Baer wrote:
From what I recall most of the framework objects should already have a
__toString() overload on them so you can just echo/dump the select itself.
- Jon
On Aug 9, 2007, at 11:34 AM, Brian Dailey wrote:
I'm just starting to dabble with Zend's framework, and I don't see an
easy way to check what the SQL output is when I'm executing a
statement. I'd like to just output the whole query so I can monitor
what it's sending. Does anyone know a quick & dirty way to do this?
--
Thanks!
- Brian Dailey
Software Developer
New York, NY
www.dailytechnology.net<support.vcf>_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
--
Thanks!
- Brian Dailey
Software Developer
New York, NY
www.dailytechnology.net
begin:vcard
fn:Brian Dailey
n:Dailey;Brian
org:;Department of Geekery
adr;dom:;;;New York;NY
email;internet:[EMAIL PROTECTED]
title:Senior Software Engineer
tel;home:423 506 0349
x-mozilla-html:FALSE
url:http://dailytechnology.net
version:2.1
end:vcard
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php