[mapserver-users] Possible to sort in a QueryByAttributes?
Bistrais, Bob
Bob.Bistrais at maine.gov
Fri Nov 13 07:18:09 PST 2009
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
More information about the MapServer-users
mailing list