To be able to use a label, you will likely also have to modify your select statement to include the columns that you want to use in labels or expressions.
Try something like: DATA "the_geom from (select myLabelColumn, the_geom from myTable) as foo using unique gid using SRID=4326" Of course, you will want to make sure that you are specifying the actual names of your unique id column and your SRID. David. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Lime Sent: Monday, August 18, 2008 1:31 PM To: John Mitchell; [email protected] Subject: Re: [mapserver-users] attach text to displayed features thatare comingfrom postgis Check out the LABELITEM property for a layer. You'll also need to define a LABEL for your class. Steve >>> On 8/18/2008 at 11:17 AM, in message <[EMAIL PROTECTED]>, "John Mitchell" <[EMAIL PROTECTED]> wrote: > Hi, > > I would like to be able to attach text to displayed features that are > coming from postgis. Currently I am just displaying points (layer > displayed below) as an ellipse from postgis, but I would like to have > text on top of each ellipse based on the contents of a field uniquely > associated to each point. > > John > > LAYER > # name of layer > NAME "gv:tasmania_cities" > GROUP "Collaboration" > > # what type of data is this? > TYPE POINT > > # always returned with interface > STATUS ON > > TRANSPARENCY 100 > > CONNECTIONTYPE postgis > > CONNECTION "user=postgres dbname=gvdb host=localhost port=5432 > password=password1117" > DATA "the_geom from tasmania_cities" > > > CLASS > STYLE > symbol "dot" > SIZE 8 > COLOR 0 0 0 > END > END > END > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
