I'm looking at the data in SQLiteAdmin, where I can just browse and see records that meet the criteria. I can search on modelID=351 to display the records, but then when I add "and startyear=1990 it returns no records, even though I can see with the first query records where this condition is in fact met.
P Kishor wrote: > On 5/19/08, Skip Evans <[EMAIL PROTECTED]> wrote: >> Even this statement >> >> SELECT * FROM bsp_options WHERE modelID=351 and >> startyear=1990 >> >> Is returning no rows and I can clearly see dozens >> that meet the criteria! > > If you are not getting rows returned, how can you clearly see dozens > of rows that meet your criteria? What you are "seeing," from what I > can tell from your earlier emails, is what is being shown in whatever > program you are using to "look" at SQLite data. It could be that this > program that you are using is showing you something other than what is > really in the db. > > Since, in another email you mention that you don't have access to the > command line tool because you are accessing the database on someone > else's server, is it possible for you to download that database on to > your own computer where you can access it from the command line shell? > > -- Skip Evans Big Sky Penguin, LLC 503 S Baldwin St, #1 Madison, WI 53703 608-250-2720 http://bigskypenguin.com =-=-=-=-=-=-=-=-=-= Check out PHPenguin, a lightweight and versatile PHP/MySQL, AJAX & DHTML development framework. http://phpenguin.bigskypenguin.com/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users