Limit 0 us definitely an incorrect usage, so maybe an exception should be thrown?
-- Hector Virgen Sent from my Droid X On Oct 2, 2010 5:15 PM, "Daniel Latter" <[email protected]> wrote: > Hi, > > I know what your saying but my point is that, is this intended behaviour to > return a number so large if a zero happend to be passed.? > > Thanks > Daniel. > > 2010/10/3 Valeriy Yatsko <[email protected]> > >> Good day >> >> > dont know if this is a bug or not but if you pass the following >> parameters >> > to the limit method on select object like so: >> > >> > ->limit(0, 10); >> > >> > It produces the following SQL: >> > >> > LIMIT 2147483647 OFFSET 10 >> > >> > now i know you should vaidate the limit val beforehand but this could >> > potentially kill someones app? >> >> >> In Zend_Db_Select, you can use the limit() method to specify the count of >> rows and the number of rows to skip. The first argument to this method is >> the desired count of rows. The second argument is the number of rows to >> skip. >> >> So you should use >> ->limit(10,0) >> instead. >> >> -- >> Валерий Яцко >> ______________________________________________________________________ >> [email protected] | http://www.artlebedev.ru >> >>
