Forum

Bookworm,

I showed how to do this in my 3rd release of the sqlite tutorial using an update statement.  But here it is with a select.

const char *sql = “SELECT text FROM todo WHERE pk=? AND foo=?”;

if (sqlite3_prepare_v2(database, sql, -1, &init_statement, NULL) != SQLITE_OK)

{

     //  Error report…

}

sqlite3_bind_int(init_statement, 1, primarykey);

sqlite3_bind_int(init_statement, 2, bar);

As you can see the question marks are read from left to right.  So as you add subsequent parameters, you just add more question marks and bind them in order.

If you are totally new, I would suggest my Hello World tutorial.

Let me know if you need more help.

Hello Brandon,

Do we always need to search using the primary key? I come from a web and MySQL background, so all this binding stuff is a bit odd to me. Like if I have an app that is, for instance, an address book, i cannot know the pk to look for if i want to search for a particular contact.  Also, can you shed any light on how I would operate with more than one table. IE, how would I initialize them separately, and query them either separately or with a JOIN.

Thanks in advance