[Zope] Representing rows from a ZSQL method

[Luis Cortes]

On Fri, 19 May 2000, you wrote:
>> 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.

Right, or instead of creating a DTML document or method by hand, you can use
the Z Search Interface ( which is a sort of wizard for creating the necessary
DTML document or method you need to 1. query user for a search criteria, and 2.
gen a html table suitable for display ).


>> 
>> 
>> > -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
>> 
>> 
>> _______________________________________________
>> Zope maillist  -  Zope@zope.org
>> http://lists.zope.org/mailman/listinfo/zope
>> **   No cross posts or HTML encoding!  **
>> (Related lists - 
>>  http://lists.zope.org/mailman/listinfo/zope-announce
>>  http://lists.zope.org/mailman/listinfo/zope-dev )
-- 
======================================================

Luis Cortes

Pollak EPD (915) 621-6113

======================================================