[Zope] Zope -> MySQL Weirdness

[Cliff Ford]

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 at 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 )