Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 66035 invoked from network); 12 Nov 2003 08:45:55 -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:45:55 -0000 Received: (qmail 9038 invoked by uid 500); 12 Nov 2003 08:45:19 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 9012 invoked by uid 500); 12 Nov 2003 08:45:18 -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 8949 invoked from network); 12 Nov 2003 08:45:18 -0000 Received: from unknown (HELO cartero.tissat.es) (62.22.156.34) by daedalus.apache.org with SMTP; 12 Nov 2003 08:45:18 -0000 Received: from capitular.tissat.es (capitular.tissat.es [195.77.30.34]) by cartero.tissat.es (Postfix) with ESMTP id 711611F3FB for ; Wed, 12 Nov 2003 09:45:29 +0100 (CET) Received: from tissat.es ([192.168.7.10]) by capitular.tissat.es (Netscape Messaging Server 3.6) with ESMTP id AAA590F for ; Wed, 12 Nov 2003 09:45:27 +0100 Message-ID: <3FB1F327.9050906@tissat.es> Date: Wed, 12 Nov 2003 09:45:27 +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: Select count(*) References: <20031125104309.D5BA.106@suzuki.email.ne.jp> 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 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