Anybody...? -----Original Message----- From: Conoly, Brett Sent: Tuesday, April 22, 2008 11:26 AM To: [email protected] 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
