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
