[mapserver-users] Possible to sort in a QueryByAttributes?

[Bistrais, Bob]

I tried using the DATA statement, but I don't have it quite right.  I
get an error.  I'm using SDE data with the SDE_92.dll plugin.  Here is
my data line:
DATA "MEGISIMS.TownPlys,SHAPE,SDE.DEFAULT, ORDER BY TOWN" 
-where TOWN is the item I'd like to sort on.

Does that look right to anyone?

I'm also trying to store the results in an array and sort that, but so
far getting out of memory errors when working with the array (over 900
individual towns).  
 

-----Original Message-----
From: Steve Lime [mailto:Steve.Lime at dnr.state.mn.us] 
Sent: Friday, November 06, 2009 11:48 AM
To: mapserver-users; Bistrais, Bob
Subject: Re: [mapserver-users] Possible to sort in a QueryByAttributes?

You'd need to store the results in a intermediate data structure and
then sort that within PHP. If you're using a database backend you can do
the sort right in the DATA statement.

Steve

>>> On 11/5/2009 at 4:22 PM, in message
<4EFF8BB964547748A07CA32961810C0415F32A0E at SOM-TEAQASMAIL1.som.w2k.state.
me.us>,
"Bistrais, Bob" <Bob.Bistrais at maine.gov> wrote:
> I'm working on a PHP script which will populate an HTML select list 
> with the results of an attribute query.  The intent is to populate the

> select list with the values of an item in a data layer.  I sort of 
> have it working.  But I'd like to sort my query results in ascending 
> order, so they appear alphabetically in the select list.  Is there a 
> way to do this in Mapscript?