Creating the sql as a string and passing it to xxxPeer.executeQuery() john mcnally
On Fri, 2002-05-24 at 09:44, [EMAIL PROTECTED] wrote: > Is there a work-around for Oracle for Torque pre-patch? > > -----Original Message----- > From: John McNally [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 24, 2002 9:18 AM > To: Turbine Torque Users List > Subject: Re: How to limit a query? > > 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]> > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
