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

Try updating to the latest trunk and see if the problem still
persists. If so, please file an issue : )

On Mar 31, 2009, at 05:10 , Alexandre Paes wrote:

>
> 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.
>