vendorParams works very well! Thanks very much Steve
bart...@osgis.nl@lists.osgeo.org Envoyé par : mapserver-users-boun...@lists.osgeo.org 23/11/2009 01:56 PM A "Daniel Morissette" <dmorisse...@mapgears.com> cc mapserver-users <mapserver-users@lists.osgeo.org> Objet Re: [mapserver-users] WMSgetFeatureInfo and variable substitution Daniel is right. Steve, I've opened up an OpenLayers bug [1]. In the meantime you can try and use vendorParams on the GetFeatureInfo control, but you need to update the property whenever your values change. Further discussion can best be done on the OL mailing list. [1] http://trac.openlayers.org/ticket/2358 Best regards, Bart > I saw your post on the openlayers list, and it seems from your > description of the problem that the SEMCDC, RCC and ORDER params are > included by OpenLayers in a GetMap request but it fails to include them > in the corresponding GetFeatureInfo request. If that's the case then > that's an issue with OpenLayers, or with the way you configure your > queryable layer in OL. I'm not fluent enough in OL personally to tell > where the solution lies, but if the params are missing in the URL then > the problem is definitely on the client side and not on the server. > > Daniel > > > steve.tout...@inspq.qc.ca wrote: >> >> Hi, >> I already posted this problem on openlayers list, but it might be a >> mapserver issue. >> >> OpenLayers.Control.WMSGetFeatureInfo doesn't use the FILTER key in my >> mapfile. This filter is define with variables like this: >> FILTER "semcdc in (%SEMCDC%) and rss in (%RSS%) and ordre in (%ORDRE%)" >> . >> >> The getMap request is succesfull but not the GetFeatureInfo request >> >> Here is the request GetFeatureInfo >> /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> >> >> In OL, I have a WMS layer define like this: >> new OpenLayers.Layer.WMS('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'}); >> >> 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_ <mailto:steve.tout...@inspq.qc.ca>_ >> __http://www.inspq.qc.ca_ <http://www.inspq.qc.ca/> >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> mapserver-users mailing list >> mapserver-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > -- > Daniel Morissette > http://www.mapgears.com/ > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
