I've had several folks ask for some ZPatterns examples with SQL. I've *finally* gotten around to providing them. They're at: http://www.zope.org/Members/sspickle The first is a school attendance application 'skeleton' with the following description: An example of ZPatterns using SQL. Gadfly is the database so everyone can use it. There are a couple of novel aspects 1) a 'generic' object management UI that is acquired by all the Specialists and 2) levers to manage all the SQL and SkinScript. After you have the products and folder installed, you'll need to create the database tables (run createAllTables_html) and then add some data. There is a very crude admin UI for each Specialist that you can get to from the main 'view' page by clicking on the link for that Specialist. Follow the "object model":attendanceModel.gif to see how to hook things up. If you change any of the ZClass propertysheets you'll need to rerun the levers to create all the SQL queries and SkinScript. (You'll probably also need to drop/re-create the relevant database tables) The second is a school lunch application 'skeleton' which is 99% similar, except that it uses a filesystem base class for the 'Lunch' object, just to show how it can be done. Feedback most welcome! thanks, -steve