Hello,
If you use values as numbers you not need quotes,
for characted date use single quote = ' (apostrof),
for example:
select o from Object o where id in list(1, 2, 3);
or
select o from Object o where name in list('name1', 'name2', 'name3');
Thanks
-----Original Message-----
From: Bruce Snyder [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 9:21 PM
To: [EMAIL PROTECTED]
Subject: Re: [castor-dev] LIST operator
Satish Cattamanchi wrote:
>
> Using LIST operator in OQL, I specify values in the format
> LIST("value1", "value2", "value3"). But the final SQL generated will
> be .. IN ( ''value'' ,''value2'', ''value3'') i.e a double quote is
> converted into 2 single quotes. It is specified w.r.t regular exp i.e
> stringliteral = "{character}". In what format should I specify the
> strings.
Satish,
I'm not even sure that you need the quotes there. Have you tried it
without?
Bruce
-----------------------------------------------------------
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
