Hi, I got an error when querying a wms layer (mapserver) with a OpenLayers.Control.WMSGetFeatureInfo request when there is a variables substitution. I have a WMS layer define like this: createWmsLayer('ecoles', '.../cgi-bin/mapserv.exe?map=MYMAP',{layers: 'ecoles', transparent: "true", format:"image/gif", SEMCDC:thisCDC, RSS: thisRSS, ORDRE: thisOrdre},{isBaseLayer: false, visibility: false,singleTile:true,transitionEffect: 'resize'});
I have 3 variables: SEMCDC, RSS, ORDRE In the mapfile I use this statement FILTER "semcdc in (%SEMCDC%) and rss in (%RSS%) and ordre in (%ORDRE%)" The getMap request is succesfull. Here is the request /cgi-bin/mapserv.exe?map=MYMAP service=WMS&version=1.1.0&request=GetFeatureInfo&layers=ecoles&query_layers=ecoles&styles=&bbox=-8820221.560815%2C5721770.182129%2C-7587445.168853%2C6361395.234705&srs=EPSG%3A900913&feature_count=3000&x=272&y=457&height=523&width=1008&info_format=text%2Fhtml Here is the response <?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?> <!DOCTYPE ServiceExceptionReport SYSTEM "http://schemas.opengis.net/wms/1.1.0/exception_1_1_0.dtd"> <ServiceExceptionReport version="1.1.0"> <ServiceException> prepare_database(): Query error. Error declaring cursor: ERROR: syntax error at or near "%" LINE 1: ...:text from ecoles WHERE (semcdc in (%SEMCDC%) ... ^ With query string: DECLARE mycursor BINARY CURSOR FOR SELECT "taux_abs"::text,"nouv"::text,asbinary(force_collection(force_2d(geom900913)),'NDR'),id::text from ecoles WHERE (semcdc in (%SEMCDC%) and rss in (%RSS%) and ordre in (%ORDRE%)) and (geom900913 && setSRID( 'BOX3D(-8493071.07981319 5795761.22549582,-8480841.15528974 5807991.15001926)'::BOX3D,900913) ) </ServiceException> </ServiceExceptionReport> How should I query the layer? Thanks Steve Steve Toutant, M. Sc. Analyste en géomatique Secteur environnement Direction de la santé environnementale et de la toxicologie Institut national de santé publique du Québec 945, avenue Wolfe Québec, Qc G1V 5B3 Tél.: (418) 650-5115 #5281 Fax.: (418) 654-3144 steve.tout...@inspq.qc.ca http://www.inspq.qc.ca
_______________________________________________ Users mailing list Users@openlayers.org http://openlayers.org/mailman/listinfo/users