Jorn, I have the following columns:
gid capakey percid capaty shape_area the_geom Thanks for helping out ! Steven On Nov 19, 2007 2:21 PM, Jørn Vegard Røsnes <[EMAIL PROTECTED]> wrote: > 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 >
