Hmmm... If a the URL overloading works with WMS getMap then it should work with getFeatureInfo. Can you confirm the former?
Steve >>> On 8/26/2009 at 10:07 AM, in message <[email protected]>, AlessioDL <[email protected]> wrote: > Hi, > > I'm creating an application based on UMN-Mapserver used as WMS server. The > application adds a filtered layer (stored in postgis) to the map, adding > only the features respondig to the filter value. > > In my mapfile I have this: > > LAYER > ... > FILTER "year = %year%" > ... > END > > I get the value of %year% from OpenLayer and it works fine: the wms layer is > filtered as expected and added to the map. > A problem comes when I try to query the filtered layer with a getfeatureinfo > request. > I obtain a syntax error near the % character. It looks like the variable is > treated as something wrong... Infact, if I replace the variable with a > static value (for example FILTER "year=2008") the getfeatureinfo works fine. > > Is there a way to obtain a working getfeatureinfo mantaining the variable > (%year%) in the FILTER? > > Thank you in advance > > > The error is this > <ServiceExceptionReport version="1.1.0"> > - > <ServiceException> > > prepare_database(): Query error. Error declaring cursor: ERROR: syntax > error at or near "%" > LINE 1: ...t from (SELECT * FROM areas)AS foo WHERE ((year = %YEAR%)) a... > ^ > > With query string: DECLARE mycursor BINARY CURSOR FOR SELECT > asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (SELECT > * FROM areas)AS foo WHERE ((year = %YEAR%)) and (the_geom && setSRID( > 'BOX3D(15.4467741267663 43.8503721970904,15.5786100642428 > 43.945370093883)'::BOX3D,4326) ) > > </ServiceException> > </ServiceExceptionReport> _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
