Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 58777 invoked from network); 11 Nov 2003 20:43:41 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 11 Nov 2003 20:43:41 -0000 Received: (qmail 53931 invoked by uid 500); 11 Nov 2003 20:43:07 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 53772 invoked by uid 500); 11 Nov 2003 20:43:06 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 53577 invoked from network); 11 Nov 2003 20:43:04 -0000 Received: from unknown (HELO mx201.mysite4now.com) (216.250.116.238) by daedalus.apache.org with SMTP; 11 Nov 2003 20:43:04 -0000 Received: (qmail 22038 invoked by uid 104); 11 Nov 2003 20:42:19 -0000 Received: from rs@reazon.com by localhost.localdomain by uid 110 with qmail-scanner-1.14 (spamassassin: 2.43-cvs. Clear:. Processed in 0.059513 secs); 11 Nov 2003 20:42:19 -0000 Received: from adsl-67-112-246-202.dsl.lsan03.pacbell.net (HELO RSC640) (67.112.246.202) by mx201.mysite4now.com with SMTP; 11 Nov 2003 20:42:19 -0000 From: "Ramesh Sabeti" To: "'Apache Torque Users List'" Subject: RE: How to update multiple rows Date: Tue, 11 Nov 2003 12:43:10 -0800 Message-ID: <000701c3a894$6b823f30$800101df@rsccd.org> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: <3FB0EF8C.9010308@metatomix.com> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N 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:wleng@metatomix.com] > 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: torque-user-unsubscribe@db.apache.org > >For additional commands, e-mail: torque-user-help@db.apache.org > > > > > > > > -- > Bill Leng > Sr. Software Engineer > Metatomix, Inc. > Tel: (901)261-8911 > Fax: (901)261-8901 > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org > For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org