I don't see you compiling the SQL statement with a prepare or testing
for errors.
RickLaird wrote:
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
