[Zope-DB] Creating a "matrix" HTML table from a database table
Fri, 7 Mar 2003 10:06:55 -0000
surely, the y-axis should be a numeric value, such as the total ie
product_count accumulated vs each day and the graph will be for that actu=
you'll probably need a 3-d graph, where x-axis is the date, y-axis will b=
the accumulated count, and z-axis the product_id!
then you should be able to pull your data using inner join statement and =
the required report as
product | day1 | day2 | day-nth
product_name | total | total | total
and so on...
From: email@example.com [mailto:firstname.lastname@example.org]On Behalf Of
Sent: 07 March 2003 08:05
Subject: [Zope-DB] Creating a "matrix" HTML table from a database table
I need to make a report from data contained in a database.
The X axis is one specific SQL call, and the Y axis is one specific SQL
For each cell I need to take data from the X and Y SQL call and do
another SQL call.
How can I speed up this, so that I I don't need to call ~80 SQL
statements to display the page?
The X-axis is the date, the Y-axis is the product, and the cell-content
is the product count for the specific date.
Get the point?
This data is of course contained in one simple table with day,product_id
and product_count accumulated.
Should be very simple, but I'm fairly fresh to Zope (and Python).
MobiLife AS | Tlf: +47 33334141 | Dir.: +47 33334143
Kilengaten 1 | Fax: +47 33334140 | Mobil: +47 91593393
3117 T=F8nsberg | email@example.com | firstname.lastname@example.org
Zope-DB mailing list