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 <danielk1...@gmail.com>:
> 
> 
> 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
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

Reply via email to