On Wed, Nov 17, 2010 at 10:20:22AM -0500, Chris Wolf scratched on the wall: > I am trying to familiarize myself with the lower-level routines for > queries, so started with the > example here:
> not working - error 25, range erorr: > > ./client test.sqlite "select * from emp where ename = '?'" fred This is not a place-holder. This is a single-character string-literal that consists of a question mark. Lose the quotes. The quotes are part of the string-literal specification, not the value itself. They're not needed for place-holders. Consider this statement if you were binding a integer, or something other than a text value. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
