On Mon, May 19, 2008 at 07:42:36PM -0500, Skip Evans scratched on the wall: > Hey all, > > For the life of me I can't figure out why the > following statement returns no rows: > > SELECT productcodesize,options FROM bsp_options > WHERE modelID=351 AND '1990' >= startyear AND > '1990' <= endyear > > I'm looking right now at a printout of records > from the query: > SELECT productcodesize,options FROM bsp_options > WHERE modelID=351 > > Where the fields are: > > modelID: 351 startyear: 1990 endyear:1993 > > ..and there are a bunch of them. > > Can anyone spot anything wrong with that query???
Do you really mean for the years to be string literals and not numbers? -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users