On Jan 31, 2010, at 9:19 AM, james pruett wrote:
> I am writing an open source program.
>
> I am having trouble getting any results using this query. This
> returns none....
>
> select * from signs where lon>-121 and lon<-119;
>
> onCreate(SQLiteDatabase db) {
> db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + _ID
> + " INTEGER PRIMARY KEY AUTOINCREMENT, " + TIME
> + " VARCHAR(45), " + TAGG
> + " VARCHAR(45), " + LAT
> + " FLOAT , " + LON
> + " VARCHAR(45), " + COG
> + " VARCHAR(45), " + MPH
> + " VARCHAR(45), " + KPH
> + " TEXT NOT NULL);");
> }
>
> Here is the database using RazorSQL v504
> select * from signs;
> _id time tag lat lon cog
> mph kph
> 1 1264890306692 test 20.0 -120.0 0.0 45.0 0.0
> 2 1264890311484 test 20.0 -120.0 0.0 45.0 0.0
> 3 1264890345263 test 20.0 -120.0 0.0 45.0 0.0
> 4 1264890346700 test 20.0 -120.0 0.0 45.0 0.0
>
> -----------
> I have tried lon= varchar(45) and also as a FLOAT, and both don't seem
> to handle negative numbers correctly.
FLOAT should work. Are you sure you tried it correctly?
> Any help appreciated!
>
> Jim
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
