Mike Marshall wrote:
>
> acQuery = sqlite3_mprintf("SELECT rowid FROM fulltext_%s WHERE contents
> MATCH '? '",sTempTableRoot.c_str());
You need to remove he quotes around the ? following MATCH. With the
quotes it is a literal string containing a question mark. Without them
it is a parameter inthe query that you can bind some string value to later.
>
> nError from the prepare is SQLITE_OK but from the bind its SQLITE_RANGE
>
This is because you don't have any parameters to be bound.
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
