[Zope] Re: Authentication Error on python script db submit

[Wayne Connolly]

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