Yah . will give it a go .
_____ From: James Dempster [mailto:[EMAIL PROTECTED] Sent: Thursday, April 17, 2008 1:20 PM To: Mark Steudel Cc: [email protected] Subject: Re: [fw-general] CALC_FOUND_ROWS vs. count(*) 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
