query postgis through wms

[Jørn Vegard Røsnes]

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