Mahalakshmi.m <[EMAIL PROTECTED]> wrote: > I want the statement to be like: > > "SELECT id, Name FROM MUSIC WHERE Name >= '1a' LIMIT 1;" > > But using prepare I could not able to get the desired statements. > > I want to bind unsigned short as text.
There are no parameters in your statement. What exactly do you plan to bind to? > Unsigned char u8_ClassificationCode=1; > > Unsigned short u16_Input=0x0061; > > if ( sqlite3_prepare(gpst_SqliteInstance,"SELECT id, Name FROM MUSIC > WHERE Name >= '%d%c' LIMIT 1;",-1,&pst_SearchPrepareStmt,0)!= > SQLITE_OK) You seem to think sqlite3_prepare works like printf, what with you using %d and %c. It doesn't. %d and %c have no special meaning in a SQL statement. Your statement has no parameters to bind. Try something like this: wchar_t text[10]; wsprintf(text, L"%d%c", u8_ClassificationCode, u16_Input); sqlite3_prepare(gpst_SqliteInstance, "SELECT id, Name FROM MUSIC WHERE Name >= ? LIMIT 1;", -1, &pst_SearchPrepareStmt, 0); sqlite3_bind_text16(pst_SearchPrepareStmt, 1, text, -1, SQLITE_TRANSIENT); Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users