db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Felipe Ramos" <fra...@tissat.es>
Subject Select count(*)
Date Wed, 12 Nov 2003 08:45:27 GMT
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


Mime
View raw message