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: fw-general@lists.zend.com 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