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