Re: [castor-dev] WHERE IN clause in OQL query

[Christophe . Demez]

Try this :

oql = db.getOQLQuery( "SELECT p FROM Product p WHERE p.number IN LIST
( '$1', '$2') ");

Christophe


                                                                                       
                                                              
                    Max Foxell                                                         
                                                              
                    <Max.Foxell@morganst        To:     [EMAIL PROTECTED]          
                                                              
                    anley.com>                  cc:                                    
                                                              
                                                Subject:     Re: [castor-dev] WHERE IN 
clause in OQL query                                           
                    08/09/01 11:12 AM                                                  
                                                              
                    Please respond to                                                  
                                                              
                    castor-dev                                                         
                                                              
                                                                                       
                                                              
                                                                                       
                                                              



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

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev