quotes and apostrophes in dbf

Andreas Albarello andreas.albarello at TERRITORIUMONLINE.COM
Thu Aug 4 10:53:50 PDT 2005


I noticed that dbf-records containing apostrophes or quotes in one of 
their fields don't show up in the attribute query results when such a 
field is referenced inside the expression.

For instance, a query like

'[ORT_NAME_I]' =~ /.*(A|a)(N|n)(D|d)(R|r).*/

produces the expected results except for the record where ORT_NAME_I is
Sant'Andrea, which doesn't show up due to the apostrophe (things behave 
exactly the same on other dbf-data, using different queries and working 
on different machines, when there's char #34 or #39 around).

I guess that things go wrong somewhere inside the parser which is called
from msEvalExpression. In fact, what we probably need to do is to escape 
any quote and apostrophe in a record as things are ok when I surround 
[ORT_NAME_I] in the example above with quotes instead of apostrophes, 
but that, viceversa, hides any record containing a quote. Of course, I 
may be wrong as well.

Has anybody else experienced this behavior too?

Best regards,
-- 
--------------------------------------------------------------------
Andreas Albarello
Territorium Online Srl/GmbH
andreas.albarello at territoriumonline.com
www.territoriumonline.com
--------------------------------------------------------------------



More information about the MapServer-users mailing list