MapServer handles the runtime input as strings always. It's only after the substitution is done that context might dictate interpreting things as a number, date or whatever.
Steve >>> On 12/8/2009 at 10:13 AM, in message <1260288815849-4133442.p...@n2.nabble.com>, GGould <graeme.go...@grandunionhousing.co.uk> wrote: > Yes correct. I added the quotes where I populate the variable - so its in > the asp. I think I tried your method but couldnt get it to work - will have > to have another attempt. > > Graeme > > > Steve Lime-2 wrote: >> >> Thanks for posting your solution, might help another user. As I understand >> it you're >> quoting the variable on the way into MapServer, right? A simpler solution >> might be >> to just adjust your filter by placing quotes around replacement string, >> like so: >> >> FILTER "placeref = '%ref_no%'" >> >> That way PostGIS will interpret it as a string. >> >> Steve >> >>>>> GGould <graeme.go...@grandunionhousing.co.uk> 12/08/09 5:15 AM >>> >> >> Hi >> >> Solved the problem by adding quote marks at the beginning and end of each >> ref_no so that the variable is seem by the map file as a string rather >> than >> an integer. >> >> Graeme >> >> >> GGould wrote: >>> >>> Hi >>> >>> Im just starting out with MapServer and have a bit of a stumbling block. >>> The following script should identify a property based on the "ref_no" >>> string variable passed to the map file. >>> >>> DATA "geometry from snh_properties" >>> FILTER "placeref = %ref_no%" >>> >>> This works for all ref_no's beginning with a whole number, however if the >>> re_no begins with a zero then it does not work. Has anyone come across >>> this before and is there a solution that hopefully wont tax my brain too >>> much. >>> >>> Cheers >>> >>> Graeme >>> >>> >>> >>> >> >> -- >> View this message in context: >> > http://n2.nabble.com/Leading-zeros-removed-from-variabel-when-passed-to-map-file-tp4125 > > 557p4131812.html >> Sent from the Mapserver - User mailing list archive at Nabble.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