Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 69906 invoked from network); 12 Nov 2003 08:54:27 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 12 Nov 2003 08:54:27 -0000 Received: (qmail 22272 invoked by uid 500); 12 Nov 2003 08:54:00 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 22258 invoked by uid 500); 12 Nov 2003 08:54:00 -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 22245 invoked from network); 12 Nov 2003 08:54:00 -0000 Received: from unknown (HELO cartero.tissat.es) (62.22.156.34) by daedalus.apache.org with SMTP; 12 Nov 2003 08:54:00 -0000 Received: from capitular.tissat.es (capitular.tissat.es [195.77.30.34]) by cartero.tissat.es (Postfix) with ESMTP id E85FF1F3FB for ; Wed, 12 Nov 2003 09:54:11 +0100 (CET) Received: from tissat.es ([192.168.7.10]) by capitular.tissat.es (Netscape Messaging Server 3.6) with ESMTP id AAA5BFF for ; Wed, 12 Nov 2003 09:54:10 +0100 Message-ID: <3FB1F532.6080203@tissat.es> Date: Wed, 12 Nov 2003 09:54:10 +0100 From: "Felipe Ramos" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20021120 Netscape/7.01 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Apache Torque Users List Subject: Re: Select count(*) References: <20031125104309.D5BA.106@suzuki.email.ne.jp> <3FB1F327.9050906@tissat.es> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit 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 Excuse is a bad example, let's think in: Select count(*) from customer where customerName='James' Felipe Ramos wrote: > Hi all, > How can I make a "Select count(*) from Customer where > customerId='1' " query using Torque 3.1 ? > > ( I know that one possibility is use the Criteria.CUSTOM but..... ) > > Toru Suzuki wrote: > >> Hi all, >> >> I used Torque3.0 and oracle >> >> I'm trying to do >> >> String note = "\*comment"; >> Criteria cri = new Criteria(); >> cri.add(PERSON.NOTE, (Object)(note + "%"), Criteria.LIKE); >> >> SQL log is >> SELECT PERSON.NAME, PERSON.NOTE FROM PERSON >> WHERE PERSON.NOTE LIKE '\comment%' >> >> I expected WHERE PERSON.NOTE LIKE '*comment%' >> >> SqlExpression.buildLike(String columnName,String criteria,SqlEnum >> comparison,boolean ignoreCase,DB db,StringBuffer whereClause) >> javadoc wrote >> criteria = "50\%" -> columnName = '50%' >> >> Why??? >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org >> For additional commands, e-mail: torque-user-help@db.apache.org >> >> >> >> > -- ------------------------ Felipe Ramos Tissat SA C/ Orense 34-9� 28020 Madrid Tel: (+34) 91 4175913 Fax: (+34) 91 4172914 Mail: framos@tissat.es ------------------------ --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org