I've become addicted to shortcuts, and I'm surprised to get an "off by one" error when using my favorite:
db().select(db.table.ALL)[id] where id is the row you want to retrieve. In my case, the row data is for the id+1 row, not the id row. I'm using the latest released version (1.98.2) on Mac OSX (source). My table definition is not weird or malformed and no errors are encountered in the program. It just returns the wrong row. The equivalent statement works fine: db(select.table.id==id).select().first() -- Joe
