[sqlite] Executing a select with like clause

[RickLaird]

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