<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>Is it possible to send a value for the where condition to Mapserver via a variable added to the end of a WMS call? Mapserver would then put this variable value into the FILTER statement for the OGR connection.</DIV>
<DIV> </DIV>
<DIV>Many thanks,</DIV>
<DIV> </DIV>
<DIV>Robert Sanson</DIV>
<DIV> </DIV>
<DIV>Robert Sanson, BVSc, MACVSc, PhD<BR>Geospatial Services<BR>AsureQuality Limited<BR>PO Box 585, Palmerston North<BR>NEW ZEALAND<BR><BR>Phone: +64 6 351-7990<BR>Fax: +64 6 351-7919<BR>Mobile: 021 448-472<BR>E-mail: sansonr@asurequality.com<BR><BR>>>> Frank Warmerdam <warmerdam@pobox.com> 29/05/2008 10:55 p.m. >>><BR>Gabriela Messner wrote:<BR>> Hi all,<BR>> <BR>> I?m do not how to use de SQL SELECT statement to select several values <BR>> in a OGR connection to a DGN file with a layer named 'level'. For this <BR>> layer, i?d like to select the values '1,3,5'. The object LAYER is posted <BR>> below.<BR>> <BR>> Thanks in advanced.<BR>> <BR>> LAYER<BR>> NAME sheet5000<BR>> STATUS ON<BR>> TYPE line<BR>> CONNECTIONTYPE OGR<BR>> CONNECTION "D:\sheet5000.DGN"<BR>> #how do i use the SQL SELECT statement?<BR>> DATA "level=1,5,7"<BR><BR>Gabriela,<BR><BR>I would suggest trying:<BR><BR>CONNECTIONTYPE OGR<BR>CONNECTION "D:\sheet5000.DGN"<BR>DATA "elements"<BR>FILTER "WHERE level in (1,5,7)"<BR><BR>With CONNECTIONTYPE OGR you can prefix your FILTER with the keyword<BR>WHERE and the rest will be passed through to OGR as an SQL style<BR>attribute filter.<BR><BR>In DGN files there is only one layer, named elements, so we provide that<BR>in the DATA statement.<BR><BR>Best regards,<BR>-- <BR>---------------------------------------+--------------------------------------<BR>I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com<BR>light and sound - activate the windows | <A href="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam</A><BR>and watch the world go round - Rush | President OSGeo, <A href="http://osgeo.org">http://osgeo.org</A><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>