Executemany throws ProgrammingError
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
oursql |
New
|
Undecided
|
Unassigned |
Bug Description
Hi,
Python: 2.7
MySQL client: 5.1.41-3ub
oursql: 0.9.3
I had posted a question about the same problem last summer:
https:/
I updated to the latest version of oursql but it seems that the bug is still there.
In a nutshell, Cursor.executemany doesn't work--or maybe I don't know how to make it work, in which case I would appreciate a better explanation in the documentation.
Traceback (most recent call last):
File "execmany.py", line 9, in <module>
cu.
File "cursor.pyx", line 138, in oursql.
097)
File "statement.pyx", line 278, in oursql.
oursql.
There seem to be a problem with setting the data_waiting attribute in statement.
query = 'select user_id, user_registration from user where user_id = ?'
params = zip([1,
cu = c.cursor()
cu.executemany(
Any help would be really appreciated!
Hi, I just had a look at this problem.
What are you expecting here? If you call executemany() with a select query, you're selecting data and throwing it away immediately..
This error message is saying you've not looked at your result set before doing another query.