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