TypeError: iterable argument required

[Íéêüëáïò Êïýñáò]

Hello, after inserting this line if "@" in mail and comment not in
("Ó÷ïëéÜóôå Þ ñùôÞóôå ìå ó÷åôéêÜ....", ""):

iam getting the following error which i dont understand

**************************************************************
163 # insert guest comments into database if form was
submitted
164 if "@" in mail and comment not in ("Ó÷ïëéÜóôå Þ ñùôÞóôå
ìå ó÷åôéêÜ....", ""):
165 try:
166 cursor.execute( '''INSERT INTO
users(mail, comment) VALUES(%s, %s)''', (mail, comment) )
mail = None, comment = None

TypeError: iterable argument required
args = ('iterable argument required',)
**************************************************************

can you help please?

 

[MRAB]

Hello, after inserting this line if "@" in mail and comment not in
("Ó÷ïëéÜóôå Þ ñùôÞóôå ìå ó÷åôéêÜ....", ""):

iam getting the following error which i dont understand

**************************************************************
163 # insert guest comments into database if form was
submitted
164 if "@" in mail and comment not in ("Ó÷ïëéÜóôå Þ ñùôÞóôå
ìå ó÷åôéêÜ....", ""):
165 try:
166 cursor.execute( '''INSERT INTO
users(mail, comment) VALUES(%s, %s)''', (mail, comment) )
mail = None, comment = None

TypeError: iterable argument required
args = ('iterable argument required',)
**************************************************************

can you help please?

Which version of Python?

Can you please paste those few lines of code (say, lines 163 to 170).

I can't see what the "mail = None, comment = None" is meant to be.

 

[Chris Angelico]

I can't see what the "mail = None, comment = None" is meant to be.

If this is to reset the two variables after inserting into the
database, you may want to use either:

mail = None; comment = None # semicolon not comma
or
mail = comment = None # chaining assignment

Is that the line with the error, though?

Chris Angelico

 

[Íéêüëáïò Êïýñáò]

Which version of Python?

Can you please paste those few lines of code (say, lines 163 to 170).

I can't see what the "mail = None, comment = None" is meant to be.

Is the same lines i posted in the 1st post

**************************************************************
# insert guest comments into database if form was submitted
if "@" in mail and comment not in ("Σχολιάστε ή Ïωτήστε με
σχετικά....", ""):
try:
cursor.execute( '''INSERT INTO users(mail, comment) VALUES(%s,
%s)''', (mail, comment) )
except MySQLdb.Error:
print ( "Error %d: %s" % (e.args[0], e.args[1]) )
**************************************************************

Also both mail and comment variables are taken from input in form
fields.

mail = form.getvalue('mail')
comment = form.getvalue('comment')