> size = sprintf( buf, "SELECT * FROM People WHERE lname = '?'" );
^^^
> rc = sqlite3_prepare( database, buf, -1, &statement, 0 );
> sqlite3_bind_text(statement, 1, "Fullman", 7, SQLITE_STATIC );
> rc = sqlite3_step(statement);
As others have pointed out, unless you omitted some code for clarity,
the SELECT is never being executed. But after you get that fixed up,
you also need to leave out the quotes around the question mark. With
the quotes in, this is a literal question mark, not an SQL variable.
Replace the SQL you have with:
"SELECT * FROM People WHERE lname = ?"
__________________________________
Discover Yahoo!
Use Yahoo! to plan a weekend, have fun online and more. Check it out!
http://discover.yahoo.com/
