On 3 Απρ, 17:01, "eryksun ()" <eryk...@gmail.com> wrote:
> 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
Whats was the problem as i have written it?
Your solution is the same as mine except the fact that you assign
values and statements into variables.
I tried it but iam getting an Internal Server Error.
In my original question can you explain to me what the meaning of the
following error is?
********************************************
mail = None, comment = None
TypeError: iterable argument required
args = ('iterable argument required',)
*********************************************
Also i noticed that if i append a query string in the end of a url
with the varibble mail attached like
http://superhost.gr/hosting.html?mail=test
then page hosting.html does load without any problem.
If i remove the query string from the ned of the URL then i'am getting
the error message i posted.
So its not that the if condition is wrong but something happens with
the form variable 'mail' .....
--
http://mail.python.org/mailman/listinfo/python-list
