I've noticed this problem as well. The OQL spec indicates using an IN
clause is possible but it doesn't seem to work. We work around the
problem by having lots of OR's instead which is a bit ugly.
Max
Alexis Machine wrote:
> How do I use the WHERE IN clause in an OQL-Query?
> I just tried the following:
>
> oql = db.getOQLQuery( "SELECT p FROM Product p WHERE
> p.number IN ( '$1', '$2') ");
> oql.bind( first);
> oql.bind(second);
> ...
> but this doesn't work. Is the IN - clause already
> supported? Can anybody help me?
>
> Thanx a lot!
>
> Alex
>
> __________________________________________________________________
> Do You Yahoo!?
> Gesendet von Yahoo! Mail - http://mail.yahoo.de
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
