query postgis through wms

[Jørn Vegard Røsnes]

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 <jorn at spacetec.no> 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