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
