<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-9" http-equiv=Content-Type>
<META content="OPENWEBMAIL" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<p><font size="2"><b>Tom,</b></font></p>
<p><strong><font size="2">At the following line I think, but I'm not sure, You should write the name of table as your old ovf file.</font></strong></p>
<p><strong></strong></p>
<p><font size="2">> <font face="Arial" size="2"> <SrcDataSource>ODBC:****/****@CABIN</SrcDataSource></font>
<br /></font></p>
<p><font size="2"><b>Please try to change the line as follows,</b></font></p>
<p><font face="Courier New" size="2"><font face="Arial"><SrcDataSource>ODBC:****/****@CABIN</SrcDataSource,</font>OGRPoints></font></p>
<p><font face="Courier New" size="2">Good luck...</font></p>
<p><font face="Courier New" size="2">Murat</font></p>
<p><font size="2"><b>On Thu, 12 Oct 2006 13:10:33 -0400, Pascoe,Tim [Burlington] wrote</b>
<br />> <font face="Arial" size="2">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>
<br />> <font face="Arial" size="2">New File:</font>
<br />> <font face="Arial" size="2"><OGRVRTDataSource></font>
<br />> <font face="Arial" size="2"> <OGRVRTLayer name="CABINPoints"></font>
<br />> <font face="Arial" size="2"> <SrcDataSource>ODBC:****/****@CABIN</SrcDataSource></font>
<br />> <font face="Arial" size="2"> <SrcSQL>SELECT * FROM OGRPoints</SrcSQL></font>
<br />> <font face="Arial" size="2"> <FID>sitedetailsid</FID></font>
<br />> <font face="Arial" size="2"> <GeometryType>wkbPoint</GeometryType></font>
<br />> <font face="Arial" size="2"> <LayerSRS>WGS84</LayerSRS></font>
<br />> <font face="Arial" size="2"> <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/></font>
<br />> <font face="Arial" size="2"> </OGRVRTLayer></font>
<br />> <font face="Arial" size="2"></OGRVRTDataSource></font>
<br />> <font face="Arial" size="2">Old FIle:</font>
<br />> <font face="Courier
New" size="2"><OGRVRTDataSource></font>
<br />> <font face="Courier New" size="2"> <OGRVRTLayer name="CABINPoints"></font>
<br />> <font face="Courier New" size="2"> <SrcDataSource>ODBC:****/****@CABIN,OGRPoints</SrcDataSource></font>
<br />> <font face="Courier New" size="2"> <SrcLayer>OGRPoints</SrcLayer></font>
<br />> <font face="Courier
New" size="2"> <FID>sitedetailsid</FID></font>
<br />> <font face="Courier New" size="2"> <GeometryType>wkbPoint</GeometryType></font>
<br />> <font face="Courier New" size="2"> <LayerSRS>WGS84</LayerSRS></font>
<br />> <font face="Courier New" size="2"> <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/></font>
<br />> <font face="Courier New" size="2"> </OGRVRTLayer></font>
<br />> <font face="Courier
New" size="2"></OGRVRTDataSource></font>
<br />> <font face="Courier New" size="2">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>
<br />> <font face="Arial" size="2">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>
<br />> <font face="Arial" size="2">Tim Pascoe</font>
<br />> --
<br />> This message has been scanned for viruses and
<br />> dangerous content by <a href="http://www.mailscanner.info/"></b><b>MailScanner</a>, and is
<br />> believed to be clean.
<br />
<br />
<br />--
<br />Open WebMail Project (<a href="http://openwebmail.org/" target="_blank">http://openwebmail.org</a>)
<br />
<br /></font></p>
</BODY>
<br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.
</HTML>