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 )