<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6618.4">
<TITLE>Strange OGR VRT Issue</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">I'm experimenting with placing my OVF file in line, in order to pass in some variables for a custom WHERE Statement. The first step I took was changing my OVF file to use the scrSQL tag with a very simple SQL statement, instead of the srcLayer tag. Both OVF files point to the same view, in the same database.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">New File:</FONT>
<BR><FONT SIZE=2 FACE="Arial"><OGRVRTDataSource></FONT>
<BR><FONT SIZE=2 FACE="Arial"> <OGRVRTLayer name="CABINPoints"></FONT>
<BR><FONT SIZE=2 FACE="Arial"> <SrcDataSource>ODBC:****/****@CABIN</SrcDataSource></FONT>
<BR><FONT SIZE=2 FACE="Arial"> <SrcSQL>SELECT * FROM OGRPoints</SrcSQL></FONT>
<BR> <FONT SIZE=2 FACE="Arial"> <FID>sitedetailsid</FID></FONT>
<BR><FONT SIZE=2 FACE="Arial"> <GeometryType>wkbPoint</GeometryType></FONT>
<BR><FONT SIZE=2 FACE="Arial"> <LayerSRS>WGS84</LayerSRS></FONT>
<BR><FONT SIZE=2 FACE="Arial"> <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/></FONT>
<BR><FONT SIZE=2 FACE="Arial"> </OGRVRTLayer></FONT>
<BR><FONT SIZE=2 FACE="Arial"></OGRVRTDataSource></FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Old FIle:</FONT>
<BR><FONT SIZE=2 FACE="Courier New"><OGRVRTDataSource></FONT>
<BR><FONT SIZE=2 FACE="Courier New"> <OGRVRTLayer name="CABINPoints"></FONT>
<BR><FONT SIZE=2 FACE="Courier New"> <SrcDataSource>ODBC:****/****@CABIN,OGRPoints</SrcDataSource></FONT>
<BR><FONT SIZE=2 FACE="Courier New"> <SrcLayer>OGRPoints</SrcLayer></FONT>
<BR> <FONT SIZE=2 FACE="Courier New"> <FID>sitedetailsid</FID></FONT>
<BR><FONT SIZE=2 FACE="Courier New"> <GeometryType>wkbPoint</GeometryType></FONT>
<BR><FONT SIZE=2 FACE="Courier New"> <LayerSRS>WGS84</LayerSRS></FONT>
<BR><FONT SIZE=2 FACE="Courier New"> <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/></FONT>
<BR><FONT SIZE=2 FACE="Courier New"> </OGRVRTLayer></FONT>
<BR><FONT SIZE=2 FACE="Courier New"></OGRVRTDataSource></FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">The problem is, the old OVF returns a proper image, while the new one returns a blank image. I ran the new file through OGRInfo and shp2ogr, and both behave properly.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">So……..why am I getting a blank image with the scrSQL tag? I'm using the latest version of the MS4W file set, but running on IIS on Windows 2000. Any suggestions would be great - it's probably somthing very simple I'm missing :)</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Tim Pascoe</FONT>
</P>
</BODY>
</HTML>