That makes sense, even though it still runs the query, but even when I order by jcr:name or nt:file it still does not return an ordered list of nodes... I could just be misunderstanding the query syntax but nothing seems to be working. Do I have to set a certain property on the node in order to make it sortable or should the query still be working?
SELECT * FROM nt:file WHERE jcr:path LIKE 'absNodePath %' ORDER BY jcr:name Thanks again -----Original Message----- From: Julian Reschke [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 10:20 AM To: [email protected] Subject: Re: Using an sql query and ORDER BY Conoly, Brett wrote: > Anybody...? As far as I understand, you can't order by jcr:path, as it's a synthesized property. BR, Julian PS: which means the query parser probably should reject the query.
