Hi Armin and All;
I have been using pmapper application for a while and I have
been impressed by its capabilities. Thanks alot to Armin and other
developers.
I use pmapper 4.0.0 on mapserver 3beta10 php 5.3 my database is postgis 1.5
in postgre 8.4.

when i use the identify tool on querying a points it returns the same result
of gid 0 for all the borehole points from the postgis database. Mind you his
happens for the layers by always returning only the first line in the
database.
when i select one point using the tool tip the it returns the first 3 lines
from the database.

Kindly guide me why my query is misbehaving.



LAYER
    NAME 'boreholes.the_geom'
    TYPE POINT
     CONNECTIONTYPE postgis
    CONNECTION "dbname='postgis' host=localhost port=5432 user='postgres'
password='xxxxx' sslmode=disable"
    DATA 'the_geom FROM "boreholes" USING UNIQUE gid USING srid=4326'
    METADATA
     'DESCRIPTION' 'Boreholes'
     'RESULT_FIELDS' 'gid, BHNO, OWNER, LOCALITY, DEPTH, YIELD, CATEGORY'
     'RESULT_HEADERS' 'gid,BHNO,OWNER,LOCALITY,DEPTH,YIELD,CATEGORY'
     'RESULT_HYPERLINK' 'BHNO'
     'LAYER_ENCODING' 'UTF-8'
      'ows_title' 'boreholes.the_geom'
    END
    STATUS DEFAULT
    TRANSPARENCY 100
    PROJECTION
    'proj=longlat'
    'ellps=WGS84'
    'datum=WGS84'
    'no_defs'
    END
    CLASS
       NAME 'boreholes.the_geom'
       STYLE
         SYMBOL "circle"
         SIZE 5.0
         OUTLINECOLOR 0 0 205
         COLOR 0 0 205
       END
    END
TEMPLATE VOID
  END


Eric
Geomatic Engineering and Geospatial Information Systems
------------------------------------------------------------------------------

_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Reply via email to