Re: Keep nodes order with JCR-SQL2 queries

2011-05-03 Thread Charles Flond
Hi Alex, It works perfectly ! Thanks for your help. Charles On Mon, May 2, 2011 at 3:57 PM, Alexander Klimetschek wrote: > On 02.05.11 15:44, "Charles Flond" wrote: > >Now, I perform a JCR-SQL2 query like that : select * from [jnt:content] as > >content where ISDESCENDANTNODE(content,'/sites/d

Re: Keep nodes order with JCR-SQL2 queries

2011-05-02 Thread Alexander Klimetschek
On 02.05.11 15:44, "Charles Flond" wrote: >Now, I perform a JCR-SQL2 query like that : select * from [jnt:content] as >content where ISDESCENDANTNODE(content,'/sites/demo/home/maincontent/') Don't use a query for this, but the navigational access: session.getNode("/sites/demo/home/maincontent/")