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-tp4125557p4131812.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
--
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.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users