[Mapserver-DE] what is wrong with my postgis query:
Heinz-Josef Lücking
h-j.luecking at ggs-bhv.de
Fre Mai 12 13:55:54 CEST 2006
Does anybody have an idea what is wrong with my query:
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) )'
Postgresql reports the error as 'ERROR: argument of AND must be type
boolean, not type integer '
thx, heinz
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)