Hi, do you have a column named oid with integer type in your table?
cheers Jørn Vegard On Monday 19 November 2007 09:48, Steven De Vriendt wrote: > Hi folks, > > I'm trying to query a postgis-layer through wms. Yet, I do not get any > query results. > Can anyone have a look at my mapfile. I have tried to label my features > too, using > a field of the postgis-table, but that doesn't seem to work too. So, my > guess it should > be something wrong in my map-file. Thanks for helping out ! > > # > # Start of map file > # > # Sample map file for a chameleon app. > # > NAME DEMO > STATUS ON > SIZE 600 500 > SYMBOLSET symbols.sym > EXTENT 77336.359625 189988.500250 90937.297125 201812.968625 > UNITS METERS > SHAPEPATH "../data" > IMAGECOLOR 255 255 255 > FONTSET fonts.txt > TRANSPARENT FALSE > > > WEB > IMAGEPATH "etc/mapserver/tmp/ms_tmp" > IMAGEURL "/tmp/" > > METADATA > "wms_title" "Aalter_WMS" > "wms_onlineresource" " > "wms_srs" "EPSG:31300" > > END > END > > > OUTPUTFORMAT > NAME png > DRIVER "GD/PNG" > MIMETYPE "image/png" > IMAGEMODE PC256 > EXTENSION "png" > END > > > SCALEBAR > IMAGECOLOR 255 255 255 > LABEL > COLOR 0 0 0 > SIZE SMALL > END > SIZE 150 5 > COLOR 255 255 255 > BACKGROUNDCOLOR 0 0 0 > OUTLINECOLOR 0 0 0 > UNITS meters > INTERVALS 5 > STATUS ON > END > > QUERYMAP > STATUS ON > SIZE 200 200 > STYLE HILITE > COLOR 255 0 0 > END > > PROJECTION > "init=epsg:31300" > END > > LAYER > NAME "Grens" > METADATA > "wms_title" "gemeentegrens" > "gml_include_items" "all" > END > CONNECTIONTYPE postgis > CONNECTION "host="" > DATA "the_geom from alr_gemline" > DUMP TRUE > TEMPLATE "ttt" > > TYPE LINE > CLASS > NAME "KadScan" > OUTLINECOLOR 208 208 208 > END > PROJECTION > "init=epsg:31300" > END > END > > LAYER > NAME "Percelen" > > CONNECTIONTYPE postgis > CONNECTION "host="" <http://192.168.102.100/> > DATA "the_geom from b_capa_percid" > TEMPLATE "ttt" > LABELITEM 'capakey' > TYPE POLYGON > CLASS > NAME "KadScan" > > OUTLINECOLOR 208 208 208 > END > METADATA > "wms_title" "percelen" > "gml_include_items" "all" > END > > PROJECTION > "init=epsg:31300" > > END > END > > > END # Map File
