I am having a problem with single quotes in a C program.
Consider a simple table
CREATE TABLE t(comp TEXT);
Lets say I use sqlite3_prepare to prepare the following string:
"SELECT rowid FROM table WHERE comp=?;"
And then I call sqlite3_bind_text to bind "abc'def" to the statement.
And then call sqlite3_step on the statement.
I am getting a return of 1 from the step. I have checked and there *is*
a row in the table with "abc'def".
Should I be calling sqlite3_mprintf("abc'def") and passing that string
off to bind?
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
