[mapserver-users] Leading zeros removed from variabel whenpassed to map file

[GGould]

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.gould at 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-tp4125557p4131812.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Re-Leading-zeros-removed-from-variabel-whenpassed-to-map-file-tp4132826p4133442.html
Sent from the Mapserver - User mailing list archive at Nabble.com.