[mapserver-users] RE: Labeling via OGR, MySQL table

[Jay Kapalczynski]

This is my ovf file: Name is the field I want to label on...
Anyone have any thoughts?

<OGRVRTDataSource>
    <OGRVRTLayer name="Coordinatedata">
        <SrcDataSource>MYSQL:coordinates_database,user=Jay,password=Passw0rd,host=127.0.0.1,port=3306,tables=coordinates</SrcDataSource>
        <SrcSQL>SELECT X,Y,Name FROM coordinates</SrcSQL>
        <GeometryType>wkbPoint</GeometryType>
                                <GeometryField encoding="PointFromColumns" x="X" y="Y"/>
                </OGRVRTLayer>
</OGRVRTDataSource>



From: Jay Kapalczynski
Sent: Thursday, April 16, 2009 12:02 PM
To: mapserver-users at lists.osgeo.org
Subject: Labeling via OGR, MySQL table

I am plotting a few points via an OVF file and MySQL table
The points show up fine...
As soon as I try to label from the MySQL table the Star points disappear...
I imagine I have some syntax issues or missing something in the map file (See below)

Any thoughts?

THANKS

HERE ARE THE POINTS
LAYER # Points from the MySQL Database
    NAME Database
    STATUS DEFAULT
    TYPE POINT
    CONNECTIONTYPE OGR
    CONNECTION './Coordinatedata1.ovf'
    DATA 'Coordinatedata'
    CLASS
       #NAME "ID"
           STYLE
               SYMBOL "star"
               SIZE 15
               COLOR 238 0 0
           END
    END
END

CANT GET THE LABELS TO SHOW UP
  LAYER # Points from the MySQL Database
    NAME Database
    STATUS DEFAULT
    TYPE POINT
    CONNECTIONTYPE OGR
    CONNECTION './Coordinatedata1.ovf'
    DATA 'Coordinatedata'
    LABELITEM 'Name'
    LABELCACHE ON
                CLASS
                LABEL
                     COLOR 0 0 0
                      SIZE 7
END
    END
END


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090416/464c7f73/attachment-0001.html