Ths is the whole snippert i'am trying so you can see what i'm tryong to do.
[code] # if bot is contained in hostname update all previous database bot hostname entries with current bot hostname for bot in bots: if bot in host: domain = '.'.join( host.split('.')[-2:] ) 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) ) if cur.rowcount(): botfound = True break [/code] As if i have a syntactical error in someplace which i'am faling to see or PyMySQL wants special treatment regarding escaping special characters. -- https://mail.python.org/mailman/listinfo/python-list