when i use this code:
(Omit some code...such as sqite3_stmt)

sqlite3_prepare("select * from table1 where $fieldname = $fieldvalue")
sqlite3_bind_text("$fieldname", "id"); //the "id" is a field of table1, this line maybe got error.
sqlite3_bind_int("$fieldvalue", 5);
sqlite3_step();
...



I wonder if these code get the SQL: 1. select * from table1 where id = 5 //this is what i want or 2. select * from table1 where 'id' = 5 //this is what i don't want!



Another question:
I use sqlite static lib in my applictiaon, and How I can get the debug info that comes from sqlite3DebugPrintf() or other?



thanks, liigo



Reply via email to