Help with MySQLdb insert with data extracted from odbc <-- Oracle

[candiazoo at attbi.com]

Can someone tell me what this means?  I mean, I guess I *know* what it means,
but why?

The insert statement into a mysql database is...

'insert into works values(?, ?, ?, ?, ? ,?)'

The invocation of the dynamic sql is...

    status = cur_mysql.execute(sql, 
        (wrk_inst, ZERO, trs_inst, aas_inst, title, NADA))

(ZERO = 0L and NADA = 'N/A')

I do a print of the wrk_inst, trs_inst, aas_inst (and zero and nada) followed by
a print of title before the error...

80956 177802 0 0 N/A
WANTED ... A BROTHER

...here is the error...

Exception in Tkinter callback
Traceback (most recent call last):
  File "C:\Python22\lib\lib-tk\Tkinter.py", line 1292, in __call__
    return apply(self.func, args)
  File "C:\Documents and Settings\mjessop\My Documents\Python Development\Catalo
g\catalog_gui.py", line 82, in engage
    catalog.extract_works()
  File "C:\Documents and Settings\mjessop\My Documents\Python Development\Catalo
g\catalog_model.py", line 249, in extract_works
    (wrk_inst, ZERO, trs_inst, aas_inst, title, NADA))
  File "C:\Python22\Lib\site-packages\MySQLdb\cursors.py", line 70, in execute
    raise ProgrammingError, m.args[0]
ProgrammingError: not all arguments converted

======
here is a description of the database table...

mysql> describe works
    -> ;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| wrk_inst | int(11)      |      | MUL | 0       |       |
| sinker   | int(11)      |      | MUL | 0       |       |
| trs_inst | int(11)      | YES  |     | 0       |       |
| aas_inst | int(11)      | YES  |     | 0       |       |
| title    | varchar(255) | YES  |     | NULL    |       |
| pub_name | varchar(80)  | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+
6 rows in set (0.03 sec)

Any thoughts?

Thank you, in advance...

+++-------------+++--------------+++
+ Michael S. Jessop                +
| Senior Web Developer             |
+ Copyright Clearance Center, Inc. +
+++-------------+++--------------+++