typecast it to a string.. Zend_Debug::dump((string) $select); echo $select; var_dump((string) $select);
It's magic __toString() will compile the sql when the object is used as a string. On Sat, Feb 21, 2009 at 12:34 AM, Deepak Shrestha <[email protected]> wrote: > Hi, > > How can we check the SQL string created by select? > > for example: > > given this > $select->where ( <conditions>); > $select->orwhere ( <conditions>); > $select->order ( <conditions>); > > > I want to check the complete SQL statement it has created > > Zend_Debug::Dump($select) doesn't provide what I wanted to know. > > Thanks > > -- > ======================= > Registered Linux User #460714 > Currently Using Fedora 8, 10 > ======================= > -- () ascii ribbon campaign - against html e-mail /\ www.asciiribbon.org - against proprietary attachments
