I use Amit's suggestion and it works fine. Bill's suggestion seem work if the WHERE criteria refers to primary key... right Bill?
> -----Original Message----- > From: Cloves Carneiro Jr. [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 11, 2003 12:59 PM > To: Apache Torque Users List > Subject: RE: How to update multiple rows > > Hey > > I am also new to Torque and have a simple question. From what you > described, using the book example, would the criteria objects for those > two UPDATE statements be the same? > > UPDATE PRICE = 0, AUTHOR = 'ME' WHERE ID>100 > and > UPDATE PRICE = 0 WHERE AUTHOR = 'ME' AND ID > 100 > > Criteria c = new Criteria(); > c.add(BookPeer.BOOK_PRICE, 0); > c.add(BookPeer.AUTHOR, "ME"); > c.add(BookPeer.BOOK_ID, 100, Criteria.LESS_THAN); > BasePeer.doUpdate(c); > > Thx > > -----Original Message----- > From: Tulsi Das [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 11, 2003 3:53 PM > To: Apache Torque Users List > Subject: RE: How to update multiple rows > > > The criteria is just a hashtable extension to store all the mappings, > later on, when calling the methods, the SQL generator knows where to > insert them ( if you are lucky ;) ) > > tulsi > > --- Ramesh Sabeti <[EMAIL PROTECTED]> escribió: > > I meant in the example provided by Bill. If you set the criteria as > > suggested, Torque would use it in the WHERE clause and not in the SET > > clause, right? > > > > > -----Original Message----- > > > From: Tulsi Das [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, November 11, 2003 12:45 PM > > > To: Apache Torque Users List > > > Subject: RE: How to update multiple rows > > > > > > It doesn´t know untill you call > > > > > > doSelect() > > > or > > > doUpdate() > > > or even > > > doDelete() methods > > > > > > that´s why it´s only called "Criteria" > > > > > > regards > > > > > > Tulsi > > > > > > --- Ramesh Sabeti <[EMAIL PROTECTED]> escribió: > > > > How does torque know that c.add(BookPeer.BOOK_PRICE, 0) is to SET > > a > > > > value and not for comparison purposes? > > > > > > > > > -----Original Message----- > > > > > From: Bill Leng [mailto:[EMAIL PROTECTED] > > > > > Sent: Tuesday, November 11, 2003 6:18 AM > > > > > To: Apache Torque Users List > > > > > Subject: Re: How to update multiple rows > > > > > > > > > > You can do something like this > > > > > Criteria c = new Criteria(); > > > > > c.add(BookPeer.BOOK_PRICE, 0); > > > > > c.add(BookPeer.BOOK_ID, 100, Criteria.LESS_THAN); > > > > > BasePeer.doUpdate(c); > > > > > > > > > > Ramesh Sabeti wrote: > > > > > > > > > > >I have a very simple question: How do you do something like > > this > > > > with > > > > > >Torque? > > > > > > > > > > > > Update book set book_price = 0 where book_id < 100 > > > > > > > > > > > >Wish there were more online resources. > > > > > > > > > > > >Thanks, > > > > > > > > > > > >Ramesh. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >--------------------------------------------------------------------- > > > > > >To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > >For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Bill Leng > > > > > Sr. Software Engineer > > > > > Metatomix, Inc. > > > > > Tel: (901)261-8911 > > > > > Fax: (901)261-8901 > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
