Re: [RDBO] using MySQL's FOUND_ROWS() feature with QueryBuilder

2008-02-14 Thread John Siracusa
On Thu, Feb 14, 2008 at 4:12 PM, Perrin Harkins <[EMAIL PROTECTED]> wrote: > On Thu, Feb 14, 2008 at 4:06 PM, Ken Prows <[EMAIL PROTECTED]> wrote: >> Sorry, I forgot to include the limit arg in my example. I do use limit so >> that I can page the data. I need to know the total matches so that I can

Re: [RDBO] using MySQL's FOUND_ROWS() feature with QueryBuilder

2008-02-14 Thread Perrin Harkins
On Thu, Feb 14, 2008 at 4:06 PM, Ken Prows <[EMAIL PROTECTED]> wrote: > Sorry, I forgot to include the limit arg in my example. I do use limit > so that I can page the data. I need to know the total matches so that I > can determine how many pages there are. In that case, I recommend that you a

Re: [RDBO] using MySQL's FOUND_ROWS() feature with QueryBuilder

2008-02-14 Thread Ken Prows
Perrin Harkins wrote: > On Thu, Feb 14, 2008 at 3:30 PM, Ken Prows <[EMAIL PROTECTED]> wrote: > >> I am trying to find a way to use MySQL's FOUND_ROWS() feature with Rose: >> >> >> http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows >> >> I am most interested

Re: [RDBO] using MySQL's FOUND_ROWS() feature with QueryBuilder

2008-02-14 Thread Perrin Harkins
On Thu, Feb 14, 2008 at 3:30 PM, Ken Prows <[EMAIL PROTECTED]> wrote: > I am trying to find a way to use MySQL's FOUND_ROWS() feature with Rose: > > > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows > > I am most interested in getting this to work with my Ma

[RDBO] using MySQL's FOUND_ROWS() feature with QueryBuilder

2008-02-14 Thread Ken Prows
I am trying to find a way to use MySQL's FOUND_ROWS() feature with Rose: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows I am most interested in getting this to work with my Manager classes so that I do not have to do a second query to find the total count u