[OpenLayers-Users] RE getFeatureInfo and variable substitution SOLVED

[Steve.Toutant at inspq.qc.ca]

added vendorParams:{ SEMCDC:thisCDC, RSS: thisRSS, ORDRE: thisOrdre}
in the WMSGetFeatureInfo options



 




Steve.Toutant at inspq.qc.ca@openlayers.org 
Envoyé par : users-bounces at openlayers.org
20/11/2009 03:52 PM

A
users at openlayers.org
cc

Objet
[OpenLayers-Users] getFeatureInfo and variable substitution









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 &quot;%&quot; 
LINE 1: ...:text from ecoles WHERE (semcdc in (%SEMCDC%) ... 
                                                             ^ 
With query string: DECLARE mycursor BINARY CURSOR FOR SELECT 
&quot;taux_abs&quot;::text,&quot;nouv&quot;::text,asbinary(force_collection(force_2d(geom900913)),&#39;NDR&#39;),id::text 
from ecoles WHERE (semcdc in (%SEMCDC%) and rss in (%RSS%) and ordre in 
(%ORDRE%)) and (geom900913 &amp;&amp; setSRID( 
&#39;BOX3D(-8493071.07981319 5795761.22549582,-8480841.15528974 
5807991.15001926)&#39;::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.toutant at inspq.qc.ca
http://www.inspq.qc.ca 
  _______________________________________________
Users mailing list
Users at openlayers.org
http://openlayers.org/mailman/listinfo/users



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/openlayers-users/attachments/20091123/47c5a01c/attachment.html