Dietmar Hummel <hum...@treibauf.ch> wrote:
> Maybe someone could help me with a little problem. I am trying to update
> an existing entry in the db
> with an update statement where one of the columns is a blob type. I have
> code that looks like this:
> 
>     sqlite3_stmt* m_pStatement = NULL;
> 
>     std::string strStatement( "UPDATE persistence SET
> name=\"blub\",expiration=\"2011-04-02\",value=\"?\" WHERE id=\"1\"" );

std::string strStatement( "UPDATE persistence SET 
name='blub',expiration='2011-04-02',value=? WHERE id=1" );

'?' (let alone "?") is not a parameter placeholder - it's a string literal 
consisting of a single character ?.
-- 
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to