Hi, see sqlite3_bind_null:
http://www.sqlite.org/capi3ref.html#sqlite3_bind_blob Martin Andrea Galeazzi schrieb: > Hi All, > I'm developing an application which relies on sqllite as back-end. Now > I face to this problem: I've got a form that allows the user to fill a > lot of fields, obliviously only a little part of them will actually be > filled, the others isn't gonna be in the search criteria. So I prepare a > parameterized query containing the whole possible fields like this: > SELECT * FROM Song WHERE id = ? AND title = ? AND album LIKE '%?%'; > How can I bind the unrequested fields? Does a trivial solution exist? > Thanks > _______________________________________________ > 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