Jay A. Kreibich wrote: > 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 >
that solved it, thanks so much. -Chris _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users