db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tulsi Das <quixote_...@yahoo.com>
Subject Re: Select count(*)
Date Wed, 12 Nov 2003 17:22:12 GMT
I use something like this:

Criteria crit = new Criteria();
crit.addSelectColumn("count(*)");
crit.add(CustomerPeer.NAME, "james");

Record result = 
  (Record) CustomerPeer.doSelectVillageRecords(crit).get(0);

if (!result.getValue(1).isNull()) {
  int count = result.getValue(1).asInt();
}

try it and tell me if it worked!

 --- Felipe Ramos <framos@tissat.es> escribió: 
> 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
>  

------------
¡Ayudá a los chicos navegando!
En noviembre, Yahoo! dona un plato de comida por cada nuevo usuario que nevegue gratis con
Yahoo! Conexión.
Conectate ya en http://conexion.yahoo.com.ar

---------------------------------------------------------------------
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