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

[P Kishor]

On Thu, Nov 12, 2009 at 4:46 PM, Bistrais, Bob <Bob.Bistrais at maine.gov> wrote:
> 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"

Remove the ","  between SDE.DEFAULT and 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?
>
>




-- 
Puneet Kishor