It works for some databases. I just committed a patch for oracle so previous versions will not take advantage. I believe mysql and postgresql support is best supported.
john mcnally On Fri, 2002-05-24 at 08:41, [EMAIL PROTECTED] wrote: > Hello, > > > > How do I limit a Torque select to only return a certain number of rows? I > ask because I see a method on Criteria called setLimit, which takes an > integer. There's no documentation I can find for it, but I guessed that it > limits the number of rows to return, except when I call it on my Criteria > object just prior to calling XXXPeer.doSelect(myCriteria), it doesn't do > anything. I still get back all the rows for the query. Maybe I guessed > wrong. Is there some other method or function somewhere that limits the > number of rows, or is this it? > > > > Also, there's a method setOffset. Again, I'm guessing that this sets the > starting point within the resultset, at which point it begins returning > rows, which would be useful for paging. Is this correct? > > > > Thanks! > > David > > > > David A. Ventimiglia > > Wells Fargo Private Client Services > > (415) 396-0414 (work) > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
