[Mapserver-users] OGR Layer with SQL

[Frank Warmerdam]

Blaine Hackett wrote:
> All
> 
> I am having a problem using SQL with OGR.  The
> following SQL statement works:
> <SrcSQL>SELECT * FROM subset (time > '6:00:00 AM'
> </SrcSQL>
> 
> but if I make it complex like this:
> <SrcSQL>SELECT * FROM subset (time > '6:00:00 AM') AND
> (time < '7:30:00 AM')  </SrcSQL>
> 
> It throws this error:
> msOGRFileOpen(): OGR error. Open failed for OGR
> connection ` ODBC:ODBC:user/pass at minnesotadata SELECT
> * FROM subset (time > '6:00:00 AM') AND (time <
> '7:30:00 AM') wkbPoint WGS84 '. File not found or
> unsupported format. 

Blaine,

Based on the error message, I would say somehow the SQL statement is
getting mushed into the datasource name itself.  Can you provide your
whole .ovf file for me to look at?

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent