[Mapserver-DE] what is wrong with my postgis query:

[Frank Koormann]

Hallo,

* Heinz-Josef Lücking <h-j.luecking at ggs-bhv.de> [060512 13:57]:
> Warning: [MapServer Error]: prepare_database(): Error executing POSTGIS 
> DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR 
> FOR SELECT 
> poikat::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::t
> ext 
> from (SELECT poigk3.gid AS gid, poigk3.poiid AS poiid, poigk3.the_geom 
> AS the_geom, poi_customer.poikategorie AS poikat from poigk3, 
> poi_customer where poi_customer.customerid='monavista' and 
> poi_customer.licensee='bis_bhv' and poi_customer.poiid=poigk3.poiid) AS 
> foo WHERE (poikat) and (the_geom && setSRID( 'BOX3D(3300000 
> 5600000,3800000 6100000)'::BOX3D,31467) )'

poikat (= poi_customer.poikategorie) scheint ein Integer zu sein und
kein boolean.

HTH,

        Frank Koormann

-- 
Frank Koormann                             <frank.koormann at intevation.de>
 Professioneller Service um Freie Software        (http://intevation.de/)
 PostGIS Support     (http://intevation.de/services/gis/postgis.de.html)