Zope Page describes problems using Zope to connect to a database.

Local documents

• Documentation on Zope and Zope/SQL prepared by the IS training group
• Information for IS web information providers (IS staff access only)
• More database examples, SQL and errors using Zope
• Providing arguments for Zope SQL queries
• Administration of access to central Zope service
• Setting up users and roles on the central and IS departmental Zope servers

Useful Information

• Example of Zope web form used to enter data into Oracle uses Python (Oct 08)
• A conference paper I presented (Oracle User Group Dec 2000).
  Zope: An alternative to WebDB Gives details about DTML, interfacing Zope with Oracle, comparison with Oracle's WebDB.
• Tutorial on how to retrieve data from an Oracle database -extracted from my conference paper (revised 20 November 2000)
• Oracle SQL solutions in DTML (revised 28 July 2003). To be used in conjunction with above tutorial. This will be constantly updated as I figure out problems during development.
  Should apply to Microsoft Access too but Microsoft Access not available from solaris installation, only via ODBC on linux or windows installation. See Comparison of Oracle and Microsoft Access SQL
• Creating Lists of Students for a given course- a master-detail example. A list of students is obtained from a summary count of students per course per year (11 April 2002)
• Example of Zope web form used to enter data into Oracle (29 April 2003) uses DHTML
• Zope Page Template references
• Zope - a Swiss Army Knife for the Web by Paul Browning
• bris-zope@bristol.ac.uk Bristol Zope group
• Information for UBIS Web site information providers
• Web Application and database hosting bulletin board
• Oracle Practice has useful sections on Oracle and zope- particularly blobs, fine grain access control
• Yvonne Aburrow's page on translating Coldfusion CFML into DTML