Hi, Ok this is a bit complicated but i try to explain. My problem was that I was using the basic openlayers template (...&template=openlayers). My parameter (...¶m=1000) was passed correctly to the Mapserver but not to the openlayers template. The template then used query without the parameter and the MapServer always used my default value for a database query.
Thanks, Janne 11/7/2016, 4:32 PM, Rahkonen Jukka (MML) kirjoitti: > Hi, > > Your SQL was missing the parenthesis, which I suppose to be mandatory with IN > http://www.1keydata.com/sql/sqlin.html > > -Jukka Rahkonen- > > > -----Alkuperäinen viesti----- > Lähettäjä: mapserver-users [mailto:[email protected]] > Puolesta Burgholzer, Robert (DEQ) > Lähetetty: 7. marraskuuta 2016 16:18 > Vastaanottaja: [email protected] > Aihe: Re: [mapserver-users] A problem with the Run-time substitution > > By includiong the single quotes in the PROCESING directive, doesn't that make > your input evaluated as a string? You example suggests that mapserver > considers single quotes around the input to be bad and rejects it - but by > putting single quotes in PROCESSING it should avoid that. > > What does the expression look like when you tried to syntax I suggested? > > -----Original Message----- > From: mapserver-users [mailto:[email protected]] On > Behalf Of Janne Tuovinen > Sent: Monday, November 07, 2016 9:08 AM > To: [email protected] > Subject: Re: [mapserver-users] A problem with the Run-time substitution > > Thank you, but this doesn't work for me. The problem is that I want to pass a > string value to my database, but the MapServer doesn't allow that and always > passes the parameters value as an integer. > > -Janne > > > 11/7/2016, 3:33 PM, Burgholzer, Robert (DEQ) wrote: >> I believe that what you want is this: >> >> PROCESSING "NATIVE_FILTER=param in '%param%' " >> >> I have not used the processing directive, so can not be sure, but the above >> syntax would work in a QUERY. >> >> >> -----Original Message----- >> From: mapserver-users [mailto:[email protected]] >> On Behalf Of Janne Tuovinen >> Sent: Monday, November 07, 2016 7:36 AM >> To: [email protected] >> Subject: [mapserver-users] A problem with the Run-time substitution >> >> Hi, >> >> I have a problem when I'm trying to pass a url-parameter to Postgis query's >> NATIVE_FILTER in my map file. >> >> My layer looks something like this: >> >> LAYER >> ... >> VALIDATION >> 'param' '.+' >> END >> ... >> DATA "shape from table" >> PROCESSING "NATIVE_FILTER=param in %param%" >> >> END # LAYER >> >> Here is some examples what I get when I try to pass some values: >> >> ...¶m=1000 = > (param in (1000)) >> ...¶m='1000' = > (param in (%param%)) >> >> What I like to have is: (param in ('1000')) >> >> Is there a way to this with the MapServer 7.0? >> >> Thank you, >> Janne >> >> _______________________________________________ >> mapserver-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> _______________________________________________ >> mapserver-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapserver-users > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
