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

[Bistrais, Bob]

I just tried this.  In Firebug, I get the following error message:

<b>Warning</b>:  [MapServer Error]: msSDELayerOpen(): SE_version_get_info(): Version not found. (-126)
 

-----Original Message-----
From: P Kishor [mailto:punk.kish at gmail.com] 
Sent: Thursday, November 12, 2009 5:50 PM
To: mapserver-users
Subject: Re: [mapserver-users] Possible to sort in a QueryByAttributes?

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