I don't think OGR based layers are working fully correctly. Tests showed that the query result was never correct and returned always only the first records of the result (this was with MS 4.10). Don't know if they removed the bug now.
You can also try to use "XY Layers" in p.mapper, it cannot display labels (MS docs are missing anything about this and why), but qyerying should work. See http://svn.pmapper.net/trac/wiki/DocManual#XYLayers for details. You need to have the PEAR DB module installed (since pm 3.2 the MDB2 module instead). armin [EMAIL PROTECTED] wrote: > Hello all. > > I guess this question should be addressed to the mapserver > mailing list, but I hope I could find a quick response to this > question. > > I have a table in mysql database where the coordinates are stored > as (degree, min, sec) coordinates. > > The connection with the database is successfull through the OGR > driver. The problem however is how to configure the layer in > order to display the locations on the map. I have downloaded > the pmapper demo map, and I'm trying to display my data on it. > > Bellow is the configuration of the layer: > LAYER > NAME "sites" > TYPE POINT > STATUS ON > CONNECTIONTYPE OGR > CONNECTION "MYSQL:db,user=user,password=pswd" > DATA "select site_name, c1.cord_deg as c1deg, c1.cord_min as c1min, > c1.cord_sec as c1sec, > c2.cord_deg as c2deg, c2.cord_min as c2min, c2.cord_sec as c2sec >>from site > inner join coordinate as c1 on c1.coordinate_id = site.coordinate_first > inner join coordinate as c2 on c2.coordinate_id = site.coordinate_second" > > LABELITEM site_name #may need to use table.name or just name depending on > your OVF file. > PROJECTION > "init=epsg:4326" > END > CLASS > SYMBOL 1 > SIZE 6 > COLOR 255 0 0 > LABEL > SIZE MEDIUM > TYPE BITMAP > COLOR 0 0 0 > END > END > DEBUG ON > END > > The intention here is to display the site_name field as a point, > where the coordinates are taken from (c1deg, c1min, c1min) and (c2deg, c2min, > c2sec) > > This however does not work. > I get the error message: > Warning: [MapServer Error]: msQueryByPoint(): No matching record(s) found. > > My knowledge on Mapserver are really limited and I'm hopping for your help. > > Anakreon > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > pmapper-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/pmapper-users > ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
