<div>When using a OGR Virtual File (often extension .ovf) file to connect to a database, you can insert a SQL query and only pull certain data. I'm currently using a similar set up using a MySQL database.</div>
<div> </div>
<div> OGR Virtual Files are documented at:<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.gdal.org/ogr/drv_vrt.html" target="_blank">http://www.gdal.org/ogr/drv_vrt.html</a></div>
<div> </div>
<div>Good Luck,</div>
<div> </div>
<div>Matt<br><br><br> </div>
<div><span class="gmail_quote">On 10/12/05, <b class="gmail_sendername">Johan Hallgren</b> <<a href="mailto:johan.e.hallgren@wmdata.se">johan.e.hallgren@wmdata.se</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hello<br><br>I have tried to find a way to query attribute in mapserver/mapscript. I<br>have found the function queryByAttributes(). I miss some functions here.
<br><br>Is there ways to do regular "SELECT fld FROM tbl WHERE id = xy" with<br>MapServer?<br>Similar question, is queries with LIKE and IN is supported?<br>I have found out that it's possible to use regular expression but only on
<br>shapefiles. What is possible if data is stored in a database?<br>Is there some documentation that I have missed, where can it be found?<br><br>Any assistance is welcome.<br><br>Regards<br>Johan<br></blockquote></div><br>