MySQLdb, problem with query with user-defined variables

[buran]

Do you get two result rows, or an error parsing the query?

Well, I didn't do that so far. Now I checked and I get the same error. So it's not the user defined variables, but the multiple SQLs...

EDIT: I haven't tried that because when I tried with stored procedure, the sql statement is single one. So I decided it's the user variables.

---

There is cursor.executemany() but I'm not able to make it run. It seems to expect params, e.g. for multiple INSERTs.
Now I will look more into that direction. thanks for the idea and the "AHA-A-A!" :-)