<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>Thanks Steve - Works perfectly!</DIV>
<DIV> </DIV>
<DIV>Robert<BR><BR>>>> "Steve Lime" <Steve.Lime@dnr.state.mn.us> 30/09/2008 6:02 a.m. >>><BR>FILTER "WHERE NAME LIKE '%%road%%'" won't work? MapServer should just replace the inner %road% and<BR>leave the outer %'s alone.<BR><BR>Steve<BR><BR><BR>>>> On 9/28/2008 at 10:03 PM, in message <48E0FC44.379F.0037.0@asurequality.com>,<BR>"Robert Sanson" <SansonR@asurequality.com> wrote:<BR>> I would like to have a FILTER section in my layer definition of an ArcSDE <BR>> layer where I formulate a "WHERE NAME LIKE ...". The problem is, is that <BR>> Mapserver defines variables using %variable%, and the "%" is also used as a <BR>> wild card in SQL-Server, which is what we use for SDE.<BR>> <BR>> <BR>> <BR>> The Layer defition is:<BR>> <BR>> <BR>> <BR>> LAYER<BR>> <BR>> NAME road<BR>> <BR>> TYPE LINE<BR>> <BR>> UNITS METERS<BR>> <BR>> STATUS ON<BR>> <BR>> CONNECTIONTYPE SDE<BR>> <BR>> CONNECTIONTYPE PLUGIN<BR>> <BR>> CONNECTION "esri-arcsde,port:nnnn,sde_crs,user,passwd"<BR>> <BR>> PLUGIN "c:/ms4w/apache/specialplugins/msplugin_sde_91.dll"<BR>> <BR>> DATA "sde_crs.SDEADMIN.CRS_ROAD,SHAPE"<BR>> <BR>> FILTER "WHERE NAME LIKE '%" + %road% + "%'"<BR>> <BR>> <BR>> <BR>> # data is queryable<BR>> <BR>> DUMP TRUE<BR>> <BR>> <BR>> <BR>> Is there any solution to this?<BR>> <BR>> <BR>> <BR>> Many thanks,<BR>> <BR>> <BR>> <BR>> Robert Sanson<BR>> <BR>> ------------------------------------------------------------------<BR>> <BR>> The contents of this email are confidential to AsureQuality. If you have <BR>> received this communication in error please notify the sender immediately and <BR>> delete the message and any attachments. The opinions expressed in this email <BR>> are not necessarily those of AsureQuality. This message has been scanned for <BR>> known viruses before delivery. AsureQuality supports the Unsolicited <BR>> Electronic Messages Act 2007. If you do not wish to receive similar <BR>> communications in future, please notify the sender of this message.<BR>> <BR>> ------------------------------------------------------------------<BR>> <BR>> <BR>> <BR>> This message has been scanned for malware by SurfControl plc. <BR>> www.surfcontrol.com<BR><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></BODY></HTML>