I am trying to execute a select with a like clause. I am having trouble passing in the string to match in the bind call.
You might notice I am writing this in cocoa. I hope the logic comes across independent of the language const char *sql = "SELECT pk FROM quotes WHERE quote like ? "; const char *value = "%Test%"; sqlite3_bind_text(searchCategories_statement, 1, [value UTF8String], -1, SQLITE_TRANSIENT); while (sqlite3_step(searchQuotes_statement) == SQLITE_ROW) { //never gets to here. } This is where I am right now. I have verified the result of the query select pk FROM quotes WHERE quote like '%Test%' returns multiple rows. Any help would be appreciated. Rick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users