Re: [Zope-DB] Python Script / ZSQL

[Andreas Jung]

--On Dienstag, 10. Mai 2005 18:24 Uhr -0700 Infor Gates 
<[EMAIL PROTECTED]> wrote:



(which is documented in the Zope Book 2.7 edition -> RDBMS chapter)
-aj


pgpGEM6zFQaUv.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] Python Script / ZSQL

[Infor Gates]

Hello Zopist

I am new and try to learn python script with ZSQL in
Zope. I have read the Zope Book. However, most of them
are in DTML and very few on python script. I have a
little knowledge on Zope and SQL but am lost in trying
to see the whole picture of zope/pythonscript/zsql.

I have a simple database record of person details.

I used a simple insertZSQL statement:
INSERT INTO person
(
  p_givenname, p_familyname, 
  p_datebirth, p_sex )
VALUES (
 
 
 
 
  );

In DTML script:






How can I do something similar in python script? 

Can anyone point me to an example? Very much
appreciated.

Thank you.

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] Zope Sybase database connection keeps closing

[Abhilasha Chaudhary]

My zope Sybase database connections keep closing for no apparent reason.
When I try to reopen the connections they sometimes give me the 
following error:

*Invalid connection string: *|database: , password: access, server: 
SYBTIGR, transactional: Y, user: access

When I make a copy of the connection object that is giving this error, 
the original connection reopens
automatically.

This behavior seems really bizarre and is causing our Zope website to 
remain unavailable.

Abhilasha
|
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db