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
