yeah looks like a tricky one, you could always extend the Zend_Db_Select class and implement your own CALC_FOUND_ROWS follow the DISTINCT as an example I think.
-- /James On Thu, Apr 17, 2008 at 9:13 PM, Mark Steudel <[EMAIL PROTECTED]> wrote: > Unless things have changed since 2007 I can't use the SQL_CALC_FOUND_ROWS > with the select methods … bummer. > > > ------------------------------ > > *From:* James Dempster [mailto:[EMAIL PROTECTED] > *Sent:* Thursday, April 17, 2008 12:48 PM > *To:* Mark Steudel > *Cc:* [email protected] > *Subject:* Re: [fw-general] CALC_FOUND_ROWS vs. count(*) > > > > Have you tried > > array('line_items_per_product' => 'CALC_FOUND_ROWS COUNT(*)')) > > I think that might work. > > -- > /James > > On Thu, Apr 17, 2008 at 8:06 PM, Mark Steudel <[EMAIL PROTECTED]> wrote: > > Hey Guys, > > > > I was looking for a way to use CALC_FOUND_ROWS in mysql, I saw in the > documentation you could get the same thing by doing this: > > > > array('line_items_per_product' => 'COUNT(*)')) > > > > If I wanted to do CALC_FOUND_ROWS instead, how would I do it utilizing the > Zend_DB? > > > > Thanks, Mark > > > > >
