Sven Richter <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to