db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ant...@di.uoa.gr
Subject Re: J1.6/Torque: avoiding the return of multiples (the same database entry, several times) with 'setDistinct()']
Date Sun, 24 Jul 2005 22:20:45 GMT
Sven Richter <srman@gmx.net> wrote:

...
>         if (iCategoryId != 0)
> 
>         {
> 
>             prodcrit.add(ProductInCategoryPeer.CAT_ID, iCategoryId);

the method you need is "addJoin" and not "add".

> 
>         }
> 
>         prodcrit.addAscendingOrderByColumn(ProductPeer.PRODUCT_NAME);
> 
>         prodcrit.setDistinct();
> 

...

> 
> Thanks a lot,
> Sven.
> 

Good luck,
 Antonis


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