Jorn, I have tried to add the following:
DATA "the_geom from b_capa_percid AS foo USING UNIQUE gid using SRD=31300" but that turns other errors. When I try to do your suggestions, the query takes forever to run... Steven On Nov 19, 2007 2:34 PM, Jørn Vegard Røsnes <[EMAIL PROTECTED]> wrote: > Hi, > > try to add the column to the tables > alter table <table> add column oid integer; > > > > On Monday 19 November 2007 14:27, Steven De Vriendt wrote: > > 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 >