[mapserver-users] Map File for Open Street Map symbology

[Lars Lingner]

thomas bonfort schrieb:
> [...]
> I don't think you can if you need to do a string comparison in your
> sql where clause, as there's no way in mapserver to escape the ' or "
> characters
>
>
>   
Ok, thanks for clarification.

>> DATA "way from (select way,osm_id ,name from planet_osm_polygon where
>> 'natural'='water'  ) as foo using unique osm_id using srid=900913"
>>
>> was not working... but I just tried it again, just to make sure I don't
>> say anything wrong... and its working. *doh*
>>     
>
> it's a valid sql clause, but useless for mapserver as it won't return
> any data (as the string 'water' and 'natural' are never equal)
>
>   
Right, I only checked if mapserver returns an error... I didn't review
the actual rendered image.


Lars