[Zope] Inserting data into database via web page

[Jonothan Farr]

In general the process is:

- create a database adapter
- create a zsql method to do the insert
- create an html form to submit the data
- create a dtml method to call the zsql method as the form's submit action

Here's a pretty good how-to that describes the entire process in detail.
http://www.zope.org/Members/jshell/ZSQLMethods-InsertingData

I find these pages to be an essential reference for zsql:

Creating SQL database methods
http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.1.4.2.html

Query templates
http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.1.4.4.html

This section covers some more advanced usage of zsql methods:

Database Method Document Template Markup Language Tags
http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.1.5.html

Hope this helps!
-jfarr