Andrea Galeazzi wrote: > 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? >
If you have multiple possibilities and combinations, my own preference would be to have a dynamically created SQL select statement. We do that for some of our more complicated object relationships. John Elrick Fenestra Technologies _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
