Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

2018-10-20 Thread Dan Kennedy
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

Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

2018-10-18 Thread Jens Alfke
> 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.

Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

2018-10-18 Thread Peter da Silva
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

Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

2018-10-18 Thread Maziar Parsijani
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

Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

2018-10-18 Thread Jens Alfke
> 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 >

Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

2018-10-18 Thread Maziar Parsijani
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

Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

2018-10-18 Thread Bob Gailer
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

[sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

2018-10-18 Thread Maziar Parsijani
Hi, how could I ignore syntax errors like this? > *SELECT *,* > > * highlight(searchsimpleenhanced, 2, '', '') text* > > * FROM searchsimpleenhanced* > > * WHERE searchsimpleenhanced MATCH 'sth][';* > there maybe nothing to match but I don't like to get syntax errors for a symbol or character