Hi,
Here the solution for my previous question posted before...
select prop.value from BaseObject as obj, StringProperty as prop where
obj.className='Blog.Categories' and obj.name = 'Blog.Categories' and
prop.id.id = obj.id and prop.id.name='name'* and (prop.value='${doc.web}' *or
prop.value='News')
--
Prathap
On Fri, Jul 18, 2008 at 11:40 AM, Prathap Pandian
<[EMAIL PROTECTED]>wrote:
> HI,
>
> How to view current space using HSQL.
>
> For Example:
>
> select prop.value from BaseObject as obj, StringProperty as prop where
> obj.className='Blog.Categories' and obj.name = 'Blog.Categories' and
> prop.id.id = obj.id and prop.id.name='name'* and prop.value = $doc.web*
>
> whether above one is correct..?
>
> --
> Prathap
>
_______________________________________________
devs mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/devs
