How to append an integer to a const char value in iPhone?

I have SQL query statement which used to display the contents in the table. The SQL statement consist of a where clause which is to be appended with numeric value as 1 ,2 3 etc depends upon the previously selected content. I am having the numeric value as int and I want it to append to SQL statement which is const char. How can I append both the values?

My query is:

select * from Book where id=1;

I h开发者_C百科ave the id value is integer

---

You simply bind the parameter. E.g.:

sqlite3 *db;
... // open database
sqlite3_stmt *pStmt;

sqlite3_prepare_v2(
  db,
  "select * from book where id = ?",
  -1,
  &pStmt,
  NULL
);

sqlite3_bind_int(pStmt, 1, bookId);

See the SQLite documentation on compiling and binding prepared statements. You can reuse the same statement more than once. sqlite3_clear_bindings lets you reset the values.

---

Is this what you're looking for?

NSString* result = [NSString stringWithFormat:@"SELECT * FROM Book WHERE id=%d", myInt];

to compose your SQL string?