2009年3月30日星期一

[fw-db] Zend_Db_Select build by means of union() and Zend_Paginator...

Hi everyone,

I've been trying for so long to get this right but i can't seem to get it
right, i'm building a query by composing several queries with union() but
once i pass this Zend_Db_Select instance to the paginator i get an exception
"No table has been specified for the FROM clause" here's how i build the
query:

$select = $db->select();
$select->union($unionqueries);

$paginator = Zend_Paginator::factory($select);

If i look at the SQL query by calling $select->assemble() everything is ok,
just this problem with the paginator... Can someone please help me get this
right? Should i just retrieve all the results to an array and use that?

TIA,

Alexandre Paes
--
View this message in context: http://www.nabble.com/Zend_Db_Select-build-by-means-of-union%28%29-and-Zend_Paginator...-tp22786727p22786727.html
Sent from the Zend DB mailing list archive at Nabble.com.

没有评论: