<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px">
<DIV>I don't have a problem with an internal quote in my map file using ms4w with Mapserver 5.2:</DIV>
<DIV> </DIV>
<DIV>FILTER "WHERE LEGAL_DESC LIKE '%%legal%%'"</DIV>
<DIV> </DIV>
<DIV>The double %% allow me to use wildcard searching.</DIV>
<DIV> </DIV>
<DIV>Robert Sanson</DIV>
<DIV><BR> <BR>>>> "Bob Basques" <Bob.Basques@ci.stpaul.mn.us> 13/02/2009 8:56 a.m. >>><BR>This was just talked about this past week in another thread.<BR><BR>I don't believe there is a method for escaping the internal quotes in the SQL statement you show. Possible option(s) would be to add a numeric column to the DB table/view for filtering on. Or make a call that returns more using a different SQL filter and use EXPRESSIONs in the Layer CLASS to filter further for display. This doesn't seem like the economical way to do things things though.<BR><BR>There was some stuff done in recent versions of MapServer though in EXPRESSIONs that may be related.<BR><BR>bobb<BR><BR><BR><BR><BR><BR>>>> Travis Kirstine <traviskirstine@gmail.com> 02/12/09 1:45 PM >>><BR>The following line does not work and I think it has something to do<BR>with the single quotes. When I use double quotes Postgres thinks I'm<BR>referring to a column name. Is there a way to escape the single<BR>quotes?<BR>DATA "geom from (select id as oid, geom from some_table where<BR>some_field = 'some_string') as myquery using SRID=-1"<BR><BR>The following line works because I'm doing a numeric comparison.<BR>DATA "geom from (select id as oid, geom from some_table where<BR>some_field_number = 99) as myquery using SRID=-1"<BR><BR><BR>-- <BR>Travis K.<BR><BR>Toronto, Canada<BR>------------------------------------------------------------<BR>"She knows there's no success like failure<BR>And that failure's no success at all."<BR>-Bob Dylan-<BR>------------------------------------------------------------<BR>_______________________________________________<BR>mapserver-users mailing list<BR>mapserver-users@lists.osgeo.org<BR><A href="http://lists.osgeo.org/mailman/listinfo/mapserver">http://lists.osgeo.org/mailman/listinfo/mapserver</A>-users<BR><BR>_______________________________________________<BR>mapserver-users mailing list<BR>mapserver-users@lists.osgeo.org<BR><A href="http://lists.osgeo.org/mailman/listinfo/mapserver">http://lists.osgeo.org/mailman/listinfo/mapserver</A>-users<BR><BR></DIV><br><br><table bgcolor=white style="color:black"><tr><td><br>------------------------------------------------------------------<br>
The contents of this email are confidential to AsureQuality. If you have received this communication in error please notify the sender immediately and delete the message and any attachments. The opinions expressed in this email are not necessarily those of AsureQuality. This message has been scanned for known viruses before delivery. AsureQuality supports the Unsolicited Electronic Messages Act 2007. If you do not wish to receive similar communications in future, please notify the sender of this message.<br>
------------------------------------------------------------------</td></tr></table><br><br>
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff">This message has been scanned for malware by SurfControl plc. </FONT><A href="http://www.surfcontrol.com/"><FONT style="BACKGROUND-COLOR: #ffffff" color=#000000>www.surfcontrol.com</FONT></A></P>
</body></HTML>