On Sun, Jan 31, 2010 at 9:42 AM, Jay A. Kreibich <j...@kreibi.ch> 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 <gpscru...@gmail.com> 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; > >> Given your data, you need lon >= -120 and lon < -119 >> >> You are not comparing with >=. You are using only > > > > That's true, but he's using 121, not 120. >
Good grief, I have no idea why I saw >-120. -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users