Re: [castor-dev] OQL question

Sun, 20 Jan 2002 02:06:16 -0800

Title: Сообщение
Bert,
In arhive list was are messages that says about this. In this messages somebody say about problem for
select a from A a where s in list("asdasd", "asdasdasd", "asdasdasdasd");
(Object A have VARCHAR2 field - s, and try list by this field)
 
But, i try it in code. All works :)))
 
if you select by number field you can use no quotes for values:
select a from A a where id list (1, 2, 3, 4)
 
But in all other type of field you MUST use double quote:
select a from A a where s list ("s1", "s2", "s3")
 
goodLuck :)
-----Original Message-----
From: Bert van Brakel [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 20, 2002 3:10 AM
To: [EMAIL PROTECTED]
Subject: Re: [castor-dev] OQL question

Ok, thanks.
----- Original Message -----
Sent: Friday, January 18, 2002 7:38 PM
Subject: Re: [castor-dev] OQL question

Hello,
No, bind list not supported.
You can use generation by youself side.
-----Original Message-----
From: Bert van Brakel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 1:23 PM
To: [EMAIL PROTECTED]
Subject: Re: [castor-dev] OQL question

Can you bind a list?
----- Original Message -----
Sent: Tuesday, January 08, 2002 10:05 PM
Subject: Re: [castor-dev] OQL question

Hello,
You can use follow form syntax:
select o from Product p where id in list(1, 45, 120)
 

Alexey Efimov - Software Engineer
Sputnik Labs
1st Kolobovsky per., 6/3
Moscow, 103051, Russia
Phone: +7 (095) 725 5444
Direct: +7 (501) 401 3217
Fax: +7 (095) 725 5443
E-Mail: mailto:[EMAIL PROTECTED]
http://www.spklabs.com

-----Original Message-----
From: Julian Loffelhardt [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 6:17 PM
To: [EMAIL PROTECTED]
Subject: [castor-dev] OQL question

Hi,
 
Is there any way to form an OQL query like:
Select p from Product p where id IN (1, 45, 120);
I have tried several ways of putting this query together but I don't seem to get it working.
 
BTW: Is there any OQL-tutorial available on the web? The Syntax explanations on the castor website go into great detail but aren't of a lot of practical use.
 
julian l�ffelhardt

Reply via email to