search

DisyInformationssysteme / Cordova-spatialite-storage

A Cordova/PhoneGap plugin to open and use sqlite databases on Android/iOS/Windows Universal(8.1)/Amazon Fire-OS/WP(7/8) with HTML5/Web SQL API
Other
24 stars 17 forks source link

Query Stopped Working with Version 1.2.0 #9

Open KimberleeDArmstrong opened 6 years ago

KimberleeDArmstrong commented 6 years ago

SELECT transform(MakePoint(-97.895904,26.322807,4326),26914) as my_geom FROM

This query works in the spatiality GUI and it worked with version 1.1.0 of this plugin, but starting with version 1.2.0 it returns an empty object for every row. results.rows.item(0) is an empty object.

Cultrarius commented 6 years ago

Interoperability with the spatialite GUI is not the goal of this plugin. The change from 1.1.0 to 1.2.0 only changed the native libraries, so there is no problem with the plugin code, but with the binaries itself.

Which version of the spatialite GUI do you use? Maybe try an older/newer version.

KimberleeDArmstrong commented 6 years ago
screen shot 2018-03-28 at 10 38 55 am

I am not worried about the interoperability with the spatialite GUI but I am pretty sure that is valid sql.
The latest version of the plugin won't return the my_geom column. If I add a * ...

"SELECT *, transform(MakePoint(-97.895904,26.322807,4326),26914) as my_geom FROM "

It will return all the rows and columns from the table but not the my_geom column. In version 1.1.0 it will return the my_geom column.