On Sunday, March 26, 2017 at 7:55:09 PM UTC+5:30, Νίκος Βέργος wrote: > Τη Κυριακή, 26 Μαρτίου 2017 - 5:19:27 μ.μ. UTC+3, ο χρήστης Ian έγραψε: > > > You need to change the placeholders back. The poster who told you to > > replace them was misinformed. > > okey altered them back to > > cur.execute('''UPDATE visitors SET (pagesID, host, ref, location, useros, > browser, visits) VALUES (%s, %s, %s, %s, %s, %s, %s) WHERE host LIKE "%%s%" > ''', > > > > (pID, domain, ref, location, > useros, browser, lastvisit, domain) ) > > but now the problem is how to exact;y type the Where HOST like "%%%" > > I MEAN HOW TO DIFFERENTIATE '%S' FROM LITERAL '%' character.
Hi , I have fixed this issue on other way you can declare variables like below and pass same to the query with strings. per1="%%%" you can assign this string (WHERE host LIKE "%%s%" ,per1) to avoid this issue. same way i resolved my query execution on cursor execute. -- https://mail.python.org/mailman/listinfo/python-list