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
<prathapmeister(a)gmail.com>wrote;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