[egenix-users] Accessing tables from a Python script in Zope

Breuer, Yvon YBreuer at tee.toshiba.de
Mon Jan 31 11:27:07 CET 2005


Hello to all members of the list,

I recently installed the mxODBCZopeDA and when I test it via the test tab everything works fine. A test via DTML worked fine too. Then I wanted to be more flexible so I added dtml-var's and again it worked just fine. But... ;-)

I want to be completely free in how I built my SQL string. And I'd rather do this directly from a Python script in Zope instead of using a ZSQL Method. I need to be this flexible because I do not know which table I have to read and which fields I have to select before I start. Final goal is to copy data from one system to the other. So therefore I've got two eGenix mxODBC Database Connections in my root folder which I called SYS1 and SYS2. The ZSQL Methods I defined are ZSQLSYS1 and ZSQLSYS2. (How obvious ;)

Enough background info, the question is: How can I execute a SQL statement from a Python script in Zope? I tried the sample coding from the Examples chapter in the mxODBC.pdf (in several ways), but this always resulted in an error.

Thank you in advance for your support.

Best regards,

Yvon Breuer


**********************************************************************
CONFIDENTIALITY DISCLAIMER

The information in this email and in any attachments is confidential and may be 
privileged.  If you are not the intended recipient, please destroy this message,
 delete any copies held on your systems and notify the sender immediately.
  
You should not retain, copy or use this email for any purpose outside of any NDA
currently existing between Toshiba Electronics Europe GmbH and yourselves.
**********************************************************************



More information about the egenix-users mailing list