At 17:30 -0400 6/21/02, Michael Jessop wrote:
Can someone tell me what this means? I mean, I guess I *know* what it
means, but why?
Placeholders for Python scripts using MySQLdb should be %s, not ?.
Convert your ? characters to %s and see what happens.
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. +
+++-+++--+++
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php