Smith, Michael ERDC-CRREL-NH wrote:
Frank,
I was testing accesing the OGR_STYLE value from a kmz file using the LIBKML
driver. Previously this had worked.
u4rt9...@maps:/htdocs/dhs/marine$ ogr2ogr -f OCI
oci:"user/p...@tns:marinetest MarineTraffic.kmz -nln MArineTest3 -lco dim=2
-lco srid-8265 -lco launder=yes -lco precision=no -sql "select *, ogr_style
from 0"
OGR: OGROpen(MarineTraffic.kmz/0x13bb63a0) succeeded as LIBKML.
ERROR 1: SQL Expression Parsing Error: syntax error
Mike,
The problem seems to be the table named 0 rather than the ogr_style
portion. Currently well formed identifiers must start with a letter or
an underscore, not a numeric digit. You can however quote it.
So 'select *, ogr_style from "0"' should work.
This is definitely a backward compatability issue, but it isn't clear to me
whether I ought to try and change it or not. Thoughts welcome.
Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmer...@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
