Das deutsche Python-Forum

#!/usr/bin/python

import sys
import MySQLdb

conn = MySQLdb.connect (host = "localhost",
        user = "x",
        passwd = "x",
        db = "x")

cursor = conn.cursor()

print "%s %s %s" % (sys.argv[1], sys.argv[2], sys.argv[3])

def put():
        cursor.execute ("""
                INSERT INTO stats (pin, nr, date)
                VALUES
                        ('%s', '%s', '%s' % (sys.argv[1], sys.argv[2], sys.argv[3]))
                """)


put()
conn.close()
cursor.close()

Traceback (most recent call last):
File "./stat.py", line 23, in ?
put()
File "./stat.py", line 16, in put
cursor.execute ("""
File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[1], sys.argv[2], sys.argv[3]))' at line 3")

DaPepsi hat geschrieben:Was mach ich falsch und wie mach ichs besser?