On Thu, Mar 28, 2013 at 3:18 PM, Νίκος Γκρ33κ <nikos.gr...@gmail.com> wrote: > Τη Πέμπτη, 28 Μαρτίου 2013 6:08:28 π.μ. UTC+2, ο χρήστης Chris Angelico > έγραψε: > >> As it says in that document, paramstyle is a top-level module >> attribute. Try printing it out. See what it says. Then match your code > > sql = '''SELECT hits FROM counters WHERE url = %s''' % page > print( sql ) > cur.execute( sql ) > > Now the error says: > > _mysql_exceptions.OperationalError: (1054, "Unknown column 'index.html' in > 'where clause'") as you cna see at my webpage
http://www.facepalm.de/ Do you understand SQL injection attacks and the concept of parameterized queries? ChrisA -- http://mail.python.org/mailman/listinfo/python-list
