On 8/8/06, Dixon <[EMAIL PROTECTED]> wrote:
I have prepared the following wide text string: L"SELECT ROWID FROM indext WHERE state='1' AND clientName='?' ORDER BY size DESC" with sqlite3_prepare16, I then call sqlite3_bind_parameter_count on the resulting statement. I get 0 back when I expected 1. Is this an invalid way to specify a placeholder for a variable that I will bind later?
You don't need to enclose ? with any quotes. Try it like this: WHERE state='1' AND clientName=? -- Nemanja Corlija <[EMAIL PROTECTED]>