<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4943.400" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=656184920-27042005><FONT face=Arial color=#0000ff size=2>What
is the lowest MapServer Version where SQL WHERE is supported in ORG VRT's?
</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=656184920-27042005><FONT face=Arial color=#0000ff size=2>I am
playing with a virtual layer that connects to an Access database using
OGR. The layer works great when I use
<SrcLayer>tlkpDestFac</SrcLayer> and call up all of the elements in
the file. </FONT></SPAN></DIV>
<DIV><SPAN class=656184920-27042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=656184920-27042005><FONT face=Arial color=#0000ff size=2>I
attempted to filter the layer by using <SrcSQL>SELECT FClass, UTMX, UTMY,
NameShort FROM tlkpDestFac WHERE FClass = 1</SrcSQL> in place of
<SrcLayer> . Using the MapServer 4.4.1 binary
from MapTools, I get the error '<FONT face="Times New Roman"
color=#000000 size=3> msDrawMap(): Image handling error. Failed to draw layer
named 'facilities'. <BR>msOGRFileOpen(): OGR error. Open failed for OGR
connection `facslf.ovf'. Failed to import LayerSRS
`epsg:32615'. ' </FONT></FONT></SPAN></DIV>
<DIV><SPAN class=656184920-27042005></SPAN> </DIV>
<DIV><SPAN class=656184920-27042005>If I hit the same .ovf file with
ogrinfo 1.2.5+ in the FW Tools package, it is read just
fine. </SPAN></DIV>
<DIV><SPAN class=656184920-27042005></SPAN> </DIV>
<DIV><SPAN class=656184920-27042005>Thanks, </SPAN></DIV>
<DIV><SPAN class=656184920-27042005></SPAN> </DIV>
<DIV><SPAN class=656184920-27042005>David. </SPAN></DIV>
<P><FONT face=Arial size=2>David Fawcett</FONT> <BR><FONT face=Arial
size=2>Minnesota Office of Environmental Assistance</FONT> <BR><FONT face=Arial
size=2>david.fawcett@moea.state.mn.us</FONT> <BR><FONT face=Arial
size=2>651.215.0200</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Tahoma size=2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>