db-torque-user mailing list archives

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


Mime
View raw message