On 28-Feb-2008, at 6:22 AM, Mahalakshmi.m wrote: > if ( sqlite3_prepare(gpst_SqliteInstance,"SELECT id, Name FROM MUSIC > WHERE > Name >= '%d%c' LIMIT 1;",-1,&pst_SearchPrepareStmt,0)!= SQLITE_OK)
That's not what a bind point looks like. Take a look here: http://www.sqlite.org/c3ref/bind_blob.html I'm not sure you can bind two values in a string this way. Maybe take a look at using one of the sqlite3_printf functions to build the value right into your query string. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
