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. Any help appreciated! Jim _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users