TypeError: iterable argument required

eryksun () eryksun at gmail.com
Sun Apr 3 16:01:36 CEST 2011


On Saturday, April 2, 2011 12:26:18 PM UTC-4, Νικόλαος Κούρας wrote:
> 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',)

Here's how I parse what you've written so far:

INVALID_COMMENTS = ("Σχολιάστε ή ρωτήστεμε σχετικά....", "")
SQL_COMMENT_FORM = "INSERT INTO users(mail, comment) VALUES(%s, %s)"

# insert guest comments into database if form was submitted
mail = form.getvalue('mail')
comment = form.getvalue('comment')
if "@" in mail and comment not in INVALID_COMMENTS:
    try:        
        cursor.execute(SQL_COMMENT_FORM % (mail, comment))
    except MySQLdb.Error as e:
        print("Error %d: %s" % (e.args[0], e.args[1]))
    else:
        mail = comment = None



More information about the Python-list mailing list