One last thing... Both python IDE's (wing and activestate) can attach to a running Zope process and allow you to set a breakpoint in the ZSQL method and then jump to the debugger to watch it execute. I assume that both IDE's come with relevant documentation. I have never used them, but I saw this demonstrated at python9, and it was very cool. There is a command line based debugger that you can use in zope. There are HOWTOs on the website. Search for 'debugging zope.' --sam sam gendler wrote:
Not really, but MySQL provides lots of debugging features. You can enable the logging of all requests, so will see if your queries are reaching the database. You can execute the same query from the mysql shell, which will allow you to see if the query does return any results. Check out the mysql documentation for more details.
Peter Parnes wrote:
Hi
Yet another MySQLDA newbie question :-)
Is there a way to get some debug information from MySQLDA? My problem is that select * from mytable always produces nothing from a table containing data (verified by talking with the mysql server directly). It doesn't matter if I test it via the test method on the connection or via a ZSQL method.
Please help yet another MySQLDA newbie :-)
/P
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- ------------------------------------------ Quidquid latine dictum sit, altum viditur.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- ---------------------------------------------------- "Nobody looks good with brown lipstick on." --Frank Zappa