|
Tom,
At the following line I think, but I'm not sure, You should write the name of table as your old ovf file.
> <SrcDataSource>ODBC:****/[EMAIL PROTECTED]</SrcDataSource>
Please try to change the line as follows,
<SrcDataSource>ODBC:****/[EMAIL PROTECTED]</SrcDataSource,OGRPoints>
Good luck...
Murat
On Thu, 12 Oct 2006 13:10:33 -0400, Pascoe,Tim [Burlington] wrote
> 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.
> New File:
> <OGRVRTDataSource>
> <OGRVRTLayer name="CABINPoints">
> <SrcDataSource>ODBC:****/[EMAIL PROTECTED]</SrcDataSource>
> <SrcSQL>SELECT * FROM OGRPoints</SrcSQL>
> <FID>sitedetailsid</FID>
> <GeometryType>wkbPoint</GeometryType>
> <LayerSRS>WGS84</LayerSRS>
> <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/>
> </OGRVRTLayer>
> </OGRVRTDataSource>
> Old FIle:
> <OGRVRTDataSource>
> <OGRVRTLayer name="CABINPoints">
> <SrcDataSource>ODBC:****/[EMAIL PROTECTED],OGRPoints</SrcDataSource>
> <SrcLayer>OGRPoints</SrcLayer>
> <FID>sitedetailsid</FID>
> <GeometryType>wkbPoint</GeometryType>
> <LayerSRS>WGS84</LayerSRS>
> <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/>
> </OGRVRTLayer>
> </OGRVRTDataSource>
> 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.
> 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 :)
> Tim Pascoe
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
--
Open WebMail Project (http://openwebmail.org)
--
This message has been scanned for viruses and
dangerous content by
MailScanner, and is
believed to be clean.
|
