The error comes from somewhere else in my class I think, as I took out
the prop2 condition things and it still does not work. Would be nice,
if you could tell me anyways, if the statement is correct for what I
plan to do.


On Tue, Feb 17, 2009 at 12:29 PM, Sebastian Kannengiesser
<> wrote:
> Hi guys,
> what is wrong here:
> --snip--
> select prop.value from BaseObject as obj, StringProperty as prop,
> StringProperty as prop2, where
> obj.className='XWiki.ServicesReviewerClass' and and
> and'name' and
>'externintern' and prop2.value='intern' order by
> prop.value
> --snap--
> I'm using this for a database list field in a class. I want to list
> all objects by the name property, but only those, where  property
> "externintern" is set to extern (static list).
> Many thanx in advance.
> Cheers
> Sebastian
users mailing list

Reply via email to