[Tutor] Passing a list, dict or tuple to MySQLdb?

2007-03-16 Thread Alan Wardroper
> I think what you want is ...(*list_of_tuples) similar to the syntax used > when calling functions with position arguments from a list. Thanks, that bypasses the "TypeError: not all arguments converted during string formatting" error but raises a new error "TypeError: execute() takes at m

[Tutor] Passing a list, dict or tuple to MySQLdb?

2007-03-07 Thread Alan Wardroper
I'm parsing some data to feed to a MySQL database, and would like to be able to pass in a list (a dictionary or a series of tuples) in the cursor.execute() or cursor.executemany() statement, but everything I've tried raises errors. I'm sure it's a matter of correct formatting the list as a sequenc

Re: [Tutor] Why this error ?

2007-02-01 Thread Alan Wardroper
Other than outdenting the whole thing, are you using a 'non-standard' character set? Are you sure that '(' isn't an alternative encoding variant that python isn't recognising as a parenthesis? I've see nthat sometimes with Japanese or unicode encoding. Just a thought... (Just to check, I tried y