jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Conoly, Brett" <Brett.Con...@digitalinsight.com>
Subject RE: Using an sql query and ORDER BY
Date Wed, 23 Apr 2008 12:09:24 GMT
Anybody...?

-----Original Message-----
From: Conoly, Brett 
Sent: Tuesday, April 22, 2008 11:26 AM
To: users@jackrabbit.apache.org
Subject: Using an sql query and ORDER BY

I'm having a problem using the ORDER BY property of an sql statement
right now, it seems that the query is actually running fine, it's just
having a problem ordering the nodes as they come back.  

I'm using         

SELECT * FROM nt:file WHERE jcr:path LIKE 'absNodePath %' ORDER BY
jcr:path

and it's not ordering them at all.

Basically all I want is to order them by name and it's not working. Any
suggestions?

Thanks,

Brett

 


Mime
View raw message