Hi all, I'm using sqlite dialect with shapefile input. An example is: ogrinfo poligoni_input.shp -dialect sqlite -sql "SELECT ST_Area(geometry) AS Area FROM poligoni_input"
It works and it's a great feature. I have some problems with MySQL spatial input. I use this syntax: ogrinfo MYSQL:"mydb,user=myuse,password=mypwd,port=3306,host=127.0.0.1" -dialect sqlite -sql "SELECT ST_Area(geometry) AS Area FROM poligoni" And I have this error: MySQL error message:FUNCTION chatwin.ST_Area does not exist Description: SELECT ST_Area(geometry) AS Area FROM poligoni It seems that the command - for mysql input - does not read "-dialect sqlite" parameter, and then it does not find ST_Area function. What do you think about? Is there some error in my procedure? Thank you very much, Andrea -- View this message in context: http://osgeo-org.1560.x6.nabble.com/sqlite-dialect-and-MySQL-spatial-input-tp5080909.html Sent from the GDAL - Dev mailing list archive at Nabble.com. _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
