Oups,
Your parameters are numeric, so do not use '$1' but simply $1
oql = db.getOQLQuery( "SELECT p FROM Product p WHERE
p.number IN LIST($1, $2) ");
It should be right :)
Christophe
Alexis
Machine To: [EMAIL PROTECTED]
<alexismchine cc:
@yahoo.de> Subject: Re: [castor-dev] WHERE IN clause
in OQL query
08/09/01
01:23 PM
Please
respond to
castor-dev
Doesen't work with parameters:
oql = db.getOQLQuery( "SELECT p FROM Product p WHERE
p.number IN LIST( 10, 20) ");
I tried this and it workx fine.
thanx Christophe
--- [EMAIL PROTECTED] schrieb: >
> 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
>
__________________________________________________________________
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
