On 25/01/2009 7:45 AM, Onion Knight wrote: > On Fri, Jan 23, 2009 at 10:41 PM, John Machin <sjmac...@lexicon.net> wrote: >> Two suggestions: >> >> (A) Check to see if the corresponding SELECT works: >> >> "SELECT *, CASE WHEN lft BETWEEN ? AND ?" >> " THEN lft + ? ELSE lft + ?" >> "END FROM tags WHERE lft BETWEEN ? AND ?", > It worked similar to the UPDATE statement, SQLITE_DONE is returned, > without any SQLITE_ROW.
So SELECT has the same problem as UPDATE. That would suggest to me that the next step would be to try the following: (1) SELECT *, (CASE .....END) FROM tags WHERE lft BETWEEN ? AND ? (2) SELECT * FROM tags WHERE lft BETWEEN ? AND ? and if (2) still finds no rows, we must be at the stage of asking you to show the whole of the minimal C program that demonstrates the problem. Cheers, John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
