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 

 

 

Reply via email to