jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Conoly, Brett" <Brett.Con...@digitalinsight.com>
Subject Using an sql query and ORDER BY
Date Tue, 22 Apr 2008 15:26:16 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message