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