RE: [sqlite] sqlite3_step() returning SQLITE_DONE for query that should return results

2008-01-19 Thread Joe Cosby
sqlite3_step() returning SQLITE_DONE for query that should > return results > > -- Joe Cosby http://joecosby.com/ I've been on aol for something like ten years. But I still hate it. :: Currently listening to The Last Supper, 1973, by Andrew Lloyd Webber/Tim Rice, from &q

[sqlite] sqlite3_step() returning SQLITE_DONE for query that should return results

2008-01-18 Thread Joe Cosby
I have a query that should return results and sqlite3_step is, sometimes, returning SQLITE_DONE instead of SQLITE_ROW. I have a table, meta_data, with two columns id INTEGER primary key, Soundid INTEGER which I know at the time of execution has the rows ID SOUNDID 38 39 39