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

Reply via email to