jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Klimetschek <aklim...@day.com>
Subject Re: SQL2 - multiple where conditions
Date Thu, 04 Mar 2010 16:26:06 GMT
On Thu, Mar 4, 2010 at 16:31, Gadbury <gadbury@googlemail.com> wrote:
> SELECT * FROM Table WHERE id IN (0,2,3);
>
> Is there an equivelent in Jackrabbit 2.0 using the query language JCR_SQL2?
>
> I know the following works (but is there a better way?) :
>
> SELECT * FROM [my:table] WHERE [id]=0 OR[id]=2 OR [id]=3

"IN" is not supported. See
http://www.day.com/specs/jcr/2.0/6_Query.html#Constraint

Regards,
Alex

-- 
Alexander Klimetschek
alexander.klimetschek@day.com

Mime
View raw message