escaping single quotes

Ace Suares ace at SUARES.NL
Sun May 1 22:53:42 EDT 2005


dear list,

I have the following situation:

1. a column in my shapefile (.dbf) that is called GEMNAAM
2. 482 gemeentes (counties), 3 of them starting with an ' (an apostroph or 
single quote).
3. a filter that looks like '[GEMNAAM]'='$gemnaam'
where $gemnaam iterates over (some of) the 482 gemeentes

The problem seems to be that the single quote in the $gemnaam is not being 
escaped, and I have no idea how to escape it.

Is there an escape mechanism for single quotes ?

I tried double quotes i.e. '[GEMNAAM]'="$gemnaam" but apparently to no 
avail.

Much obliged for any hint. (However, that won't bring back the past 4 
hours of my life).

_ace



-- 
I wanna be the squeezer, and not the squeezie.
	- Bootsy

Ace Suares' Internet Consultancy
mail: PObox 2599, 4800 CN Breda, The Netherlands
phone: +31 6 244 33 608 (Jan Veuger, support Netherlands)
emergency: +599 786 23 73
voicemail & fax: +31 848 707 705
web: http://www.suares.nl email: support at suares.nl


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050501/af3a8e81/attachment.bin


More information about the mapserver-users mailing list