see http://svn.pmapper.net/trac/wiki/UpgradeInfo#MapServer5.6.x
you need to use the current trunk or latest-stable (from SVN or http://www.pmapper.net/download.shtml). Or avoid Mapserver > 5.4 until the guys will have finally decided how they want to have the query working on database driven layers... armin On 02/06/2010 17:54, Eric Omwanza wrote: > 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 > ------------------------------------------------------------------------------ _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
