Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"
On 10/18/2018 04:58 PM, Maziar Parsijani wrote: Hi, how could I ignore syntax errors like this? *SELECT *,* * highlight(searchsimpleenhanced, 2, '', '') text* * FROM searchsimpleenhanced* * WHERE searchsimpleenhanced MATCH 'sth][';* You can use double quotes to search for a token that contains characters that are special to FTS5. e.g. WHERE col MATCH '"sth]["' is not a syntax error. Dan. there maybe nothing to match but I don't like to get syntax errors for a symbol or character like([ ] () , . @ ...) ___ 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
Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"
> On Oct 18, 2018, at 11:50 AM, Maziar Parsijani > wrote: > > It will crash or exit the program. You’re not handling errors correctly, then. I think you said you’re using Python? Then the query will probably throw a Python exception; you need to catch that and handle it appropriately. —Jens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"
Don't put raw user input where code is expected. Match strongs are code. You need to encapsulate (eg escape) or filter (delete bad characters) match strings outside sqlite. On Thu., 18 Oct. 2018, 13:50 Maziar Parsijani, wrote: > It will crash or exit the program. > > On Thu, Oct 18, 2018 at 2:27 PM Jens Alfke wrote: > > > > > > > > On Oct 18, 2018, at 11:17 AM, Maziar Parsijani < > > maziar.parsij...@gmail.com> wrote: > > > > > > I just search for words an alphabets in different languages with python > > and > > > my database is sqlite but I need to do something to not getting error > > when > > > user input a wrong character like the ones that I told before.I can ban > > > user to not input these characters but I am curious to find a way on > > sqlite. > > > > What’s wrong with getting an error? If the error code or message is > > specific enough, you can detect it and tell the user they’ve entered > > invalid characters. > > > > —Jens > > ___ > > 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
Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"
It will crash or exit the program. On Thu, Oct 18, 2018 at 2:27 PM Jens Alfke wrote: > > > > On Oct 18, 2018, at 11:17 AM, Maziar Parsijani < > maziar.parsij...@gmail.com> wrote: > > > > I just search for words an alphabets in different languages with python > and > > my database is sqlite but I need to do something to not getting error > when > > user input a wrong character like the ones that I told before.I can ban > > user to not input these characters but I am curious to find a way on > sqlite. > > What’s wrong with getting an error? If the error code or message is > specific enough, you can detect it and tell the user they’ve entered > invalid characters. > > —Jens > ___ > 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
Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"
> On Oct 18, 2018, at 11:17 AM, Maziar Parsijani > wrote: > > I just search for words an alphabets in different languages with python and > my database is sqlite but I need to do something to not getting error when > user input a wrong character like the ones that I told before.I can ban > user to not input these characters but I am curious to find a way on sqlite. What’s wrong with getting an error? If the error code or message is specific enough, you can detect it and tell the user they’ve entered invalid characters. —Jens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"
hi, I just search for words an alphabets in different languages with python and my database is sqlite but I need to do something to not getting error when user input a wrong character like the ones that I told before.I can ban user to not input these characters but I am curious to find a way on sqlite. On Thu, Oct 18, 2018 at 8:25 AM Bob Gailer wrote: > On Oct 18, 2018 5:59 AM, "Maziar Parsijani" > wrote: > > > > Hi, > > how could I ignore syntax errors like this? > > > > > *SELECT *,* > > > > > > * highlight(searchsimpleenhanced, 2, '', '') text* > > > > > > * FROM searchsimpleenhanced* > > > > > > * WHERE searchsimpleenhanced MATCH 'sth][';* > > As I understand the documentation match must be defined someplace what is > the definition of match in your case? Or what are you trying to accomplish > by using match? > ___ > 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
Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"
On Oct 18, 2018 5:59 AM, "Maziar Parsijani" wrote: > > Hi, > how could I ignore syntax errors like this? > > > *SELECT *,* > > > > * highlight(searchsimpleenhanced, 2, '', '') text* > > > > * FROM searchsimpleenhanced* > > > > * WHERE searchsimpleenhanced MATCH 'sth][';* As I understand the documentation match must be defined someplace what is the definition of match in your case? Or what are you trying to accomplish by using match? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users