On Thu, Nov 12, 2009 at 4:46 PM, Bistrais, Bob <[email protected]> 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:[email protected]] > 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 > <4eff8bb964547748a07ca32961810c0415f32...@som-teaqasmail1.som.w2k.state. > me.us>, > "Bistrais, Bob" <[email protected]> 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 _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
