<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; FONT: 10pt Tahoma">
<DIV>I would like to have a FILTER section in my layer definition of an ArcSDE layer where I formulate a "WHERE NAME LIKE ...". The problem is, is that Mapserver defines variables using %variable%, and the "%" is also used as a wild card in SQL-Server, which is what we use for SDE.</DIV>
<DIV> </DIV>
<DIV>The Layer defition is:</DIV>
<DIV> </DIV>
<DIV>LAYER<BR> NAME road<BR> TYPE LINE<BR> UNITS METERS<BR> STATUS ON<BR> CONNECTIONTYPE SDE<BR> CONNECTIONTYPE PLUGIN<BR> CONNECTION "esri-arcsde,port:nnnn,sde_crs,user,passwd"<BR> PLUGIN "c:/ms4w/apache/specialplugins/msplugin_sde_91.dll"<BR> DATA "sde_crs.SDEADMIN.CRS_ROAD,SHAPE"<BR> FILTER "WHERE NAME LIKE '%" + %road% + "%'"</DIV>
<DIV> </DIV>
<DIV> # data is queryable<BR> DUMP TRUE</DIV>
<DIV> </DIV>
<DIV>Is there any solution to this?</DIV>
<DIV> </DIV>
<DIV>Many thanks,</DIV>
<DIV> </DIV>
<DIV>Robert Sanson</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>