Hi Dan, I did not know that. What was the reason that it did not work before 3.30?
Regards, Hartwig > Am 2019-10-31 um 19:16 schrieb Dan Kennedy <[email protected]>: > > > On 1/11/62 00:32, mailing lists wrote: >> For normal tables I can use something like: >> >> SELECT * FROM Names WHERE FirstNames=? AND or OR LastName=?; >> >> For FTS tables I can only use >> >> SELECT * FROM FTSNames WHERE FirstNames MATCH ? OR LastName MATCH ?; AND is >> not supported (still do not know why) >> >> Is there any possibility to use prepared statements for FTS tables with an >> AND condition? I like to prevent code injection. > > As of 3.30.0, should work with FTS5. > > Dan. > > >> >> Regards, >> Hartwig >> >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
