Re: [sqlite] negative numbers

2010-01-31 Thread P Kishor
On Sun, Jan 31, 2010 at 9:42 AM, Jay A. Kreibich wrote: > On Sun, Jan 31, 2010 at 09:11:21AM -0600, P Kishor scratched on the wall: >> On Sun, Jan 31, 2010 at 8:19 AM, james pruett wrote: >> > I am writing an open source program. >> > >> > I am having trouble getting any results using this query.

Re: [sqlite] negative numbers

2010-01-31 Thread Jay A. Kreibich
On Sun, Jan 31, 2010 at 09:11:21AM -0600, P Kishor scratched on the wall: > On Sun, Jan 31, 2010 at 8: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>

Re: [sqlite] negative numbers

2010-01-31 Thread P Kishor
On Sun, Jan 31, 2010 at 8: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

Re: [sqlite] negative numbers

2010-01-31 Thread Simon Slavin
On 31 Jan 2010, at 2:19pm, james pruett wrote: > 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 >+ "

Re: [sqlite] negative numbers

2010-01-31 Thread D. Richard Hipp
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 "

[sqlite] negative numbers

2010-01-31 Thread james pruett
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 AUTOI