[Zope] Representing rows from a ZSQL method

[J. Atwood]

Good and bad news.. There is no real "product" to do this.. but it is not at
all hard to do with Zope tools..

> For example:
> -Displaying an order on the web with the order header (consisting of the
> client name, address, ZIP, etc.) and the order lines with the products to
> purchase.

This is a combination of a ZSQL Method (to database of you choice) and
displayed using a DTML-IN tags. No biggy.


> -Displaying a list of invoices between two dates with several columns
> (Invoice date, amount, VAT, invoice number, etc.).

Same thing. Create another ZSQL Method that calls the list and display it
using DTML-IN to iterate over the list. Display the data you want with the
DTML or limit it in the SQL statement.

> -Displaying a price list of our products with several columns (reference,
> description, price, weight, etc.) and grouping the products by different
> criteria. For example inserting a row with the brandname of the next group
> of products or inserting a row of the product type.

Same deal.. same ease..

Take a look at http://fundraising.gotschool.com which is 100% pure Zope with
a PostgreSQL backend that serves up almost everything (90% of what you see).
I have about 25 ZSQL Methods doing the work for the entire site with lots of
database interactivity (reading, writing, updating).

Start with the ZSQL Guide some How-Tos, the ZDP and when you get stuck send
a message to the group here.

Enjoy,
J