Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (nike.apache.org: domain of Brett.Conoly@digitalinsight.com
 designates 67.135.240.36 as permitted sender)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Using an sql query and ORDER BY
Date: Wed, 23 Apr 2008 08:09:24 -0400
Message-ID: 
 <7E79528FEA116746A9B896C817C51E5B02D57C29@athexm01.corp.ad.diginsite.com>
In-Reply-To: 
 <7E79528FEA116746A9B896C817C51E5B02D57C28@athexm01.corp.ad.diginsite.com>
Thread-Topic: Using an sql query and ORDER BY
Thread-Index: AcikjTUJjeLt/QAsTLqEQewq1Mc59QAraA+g
References: 
 <7E79528FEA116746A9B896C817C51E5B02D57C28@athexm01.corp.ad.diginsite.com>
From: "Conoly, Brett" <Brett.Conoly@digitalinsight.com>
To: <users@jackrabbit.apache.org>

Anybody...?

-----Original Message-----
From: Conoly, Brett=20
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. =20

I'm using        =20

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

=20