Hi all! I must manage a lot of information coming from a database and represent it on the web. 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. -Displaying a list of invoices between two dates with several columns (Invoice date, amount, VAT, invoice number, etc.). -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. Is there a product for zope to acomplish this?
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
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 ======================================================
Juan Carlos Coruña wrote:
Hi all!
I must manage a lot of information coming from a database and represent it on the web.
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. -Displaying a list of invoices between two dates with several columns (Invoice date, amount, VAT, invoice number, etc.). -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.
Is there a product for zope to acomplish this?
_______________________________________________ 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 )
Use A Zsearch Interface. I have been playing around with this type of thing too. Richard
participants (4)
-
J. Atwood -
Juan Carlos Coruña -
Luis Cortes -
Richard Smith