[Cartoweb-users] pb with URL request ?id_recenter_layer...

[o.bonnefon@libertysurf.fr]

Hello,

before trying to use the locate plugin, I've tested the URL
request :
?id_recenter_layer=communes&id_recenter_ids=2655

and I get this error :

Error in prepare_database(): Error executing POSTGIS DECLARE
(the actual query) statement:
'DECLARE mycursor BINARY CURSOR FOR SELECT
"gid"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
from sira_communes WHERE (gid IN ) and (the_geom && setSRID(
'BOX3D(609374.285714286 1876642.99999999,1075155.71428572
2202689.99999999)'::BOX3D,find_srid('','sira_communes','the_geom')
))' 

Postgresql reports the error as 'ERREUR:  erreur de syntaxe
sur ou près de «)» at character 151

It seems that the gid value is not taken into account :
WHERE (gid IN) instead of (gid IN (2655)).

I'm using Mapserver 4.10 on Debian Etch.

What can I do to solve the problem ?

Thanks

Olivier BONNEFON

------------------------ ALICE C'EST ENCORE MIEUX AVEC CANAL+ LE BOUQUET ! ---------------
Découvrez vite l'offre exclusive ALICEBOX et CANAL+ LE BOUQUET, en cliquant ici http://alicebox.fr
Soumis à conditions.