Tino, You are correct, as long as you take into account that MySQL has limitations as does zope. External Methods may help but not completely. The fact is that as the MySQL 4 is very buggy and incorrectly documented also it does allow mixed inserts and updates... so im still using 3.23. Actually i hate MySQL now... it is crap. Im moving over to PostGreSQL. atleast it is DBAPI-2.0 complient...better to bite my tounge though... mysql in our dev environ is hopelessly sad.. makes me go koo-koo. --- In zope@yahoogroups.com, Tino Wildenhain <tino@w...> wrote:

Hi Wayne,

would it not be far more easy to just use a MySQLDA (mysql zope database adaptor) and write your statements to ZSQL Methods?

The problem with classes and objects not prepared for the zope security engine - you cannot access their data in the worst case.

Regards Tino

Wayne Connolly wrote:

...

Phil,

Thanks for the reply.

It is a python script not a external method in zope. The python script is at the domain root.

I read here

http://images.devshed.com/Server_Side/Python/PythonMySQL/PythonMySQL.pdf

...

that its possible and baiscaliy repurposed it for my own needs.

I really need this py script to connect to the mysql db to do an UPDATE (then if the UPDATE fails) do a INSERT.

Any idea's?

_______________________________________________ Zope maillist - Zope@z... 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 )

__________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com