<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY>
<DIV>
<P><FONT size=2><SPAN class=572084615-18102005><FONT face=Arial><FONT
face="Times New Roman">Running </FONT></FONT></SPAN>into minor issues with the
Chameleon query for <SPAN class=572084615-18102005><FONT
face=Arial>a </FONT></SPAN>French WMS that we're serving.</FONT></P>
<P><FONT size=2>The ovf file has an sql statement that includes something
like:</FONT></P>
<P><FONT size=2>Select city as "l'emplacement_de_la_station" etc.</FONT></P>
<P><FONT size=2>Chameleon Query widget (or Mapserver WMS) is choking on that
apostrophe. This sort of thing works fine for characters with french accents
(e.g. select air1_map_2005.id as "numéro_de_la_station"), but it's not working
with this apostrophe situation.</FONT></P>
<P><FONT size=2>Our solution would be to <SPAN
class=572084615-18102005><FONT face=Arial> do </FONT></SPAN>something
like using another sequence of characters and doing a search and replace in the
query widget to get the proper thing. But <FONT face=Arial><SPAN
class=572084615-18102005> does anyone </SPAN><SPAN
class=572084615-18102005> </SPAN><SPAN
class=572084615-18102005> </SPAN></FONT> know how to fix this
properly?<SPAN class=572084615-18102005><FONT face=Arial> Or how to test
where the error is occuring? </FONT></SPAN></FONT></P>
<P><FONT size=2>The query works fine in SQL, so I know it's a
mapserver <SPAN class=572084615-18102005><FONT
face=Arial> or </FONT></SPAN>chameleon thing - it doesn't like this
character (') in a fieldname.</FONT></P>
<P><FONT size=2>I've tried escaping it (in the .ovf file) using 2 apostrophes ''
and I also tried \' but the chameleon query keeps showing No results for the
layer.</FONT></P>
<P><SPAN class=572084615-18102005><FONT size=2>Sorry for
crossposting.</FONT></SPAN></P>
<P><FONT face=Arial size=2><SPAN class=572084615-18102005> D.
Pagurek</SPAN></FONT></P></DIV></BODY></HTML>