What happens when you run a Select query from the Test tab of the Database Connection object (select * from <tablename>)? That sometimes gives a more explicit error message from the database. Cliff Tom Rectenwald wrote:
Hello,
I am just starting to learn Zope and am having trouble getting it to communicate with mySQL.
Here is what I have done thus far:
- Built and compiled MySQLdb and ZMySQLDA. - Installed the 'Z MySQL Database Connection. - Entered in the 'Database Connection String' (DB, user, password)
Once done, I went to the 'Test' tab and here is where things get weird:
- I can run an INSERT statement with no trouble and verify that the DB is updated. - However, whenever I run any sort of SELECT query I get the following error:
Error Type: TypeError Error Value: object does not support item assignment
I also get this error when trying to put a SELECT in Z SQL Method. I'm very new at this stuff and come from a PHP/Perl/mySQL/postgreSQL background, so any help at all is appreciated. If desired, I can send the error_log output as well. I just don't get it. :-(
Thank you for an help, suggestions, advice. I've googled this to bits to no avail. I am really enjoying Zope so far; just wish I understood it better.
Regards, Tom
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )