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]
