[Zope-DB] Creating a "matrix" HTML table from a database table

Norman Khine norman@khine.net
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...

-----Original Message-----
From: zope-db-admin@zope.org [mailto:zope-db-admin@zope.org]On Behalf Of
Robin Smidsr=F8d
Sent: 07 March 2003 08:05
To: zope-db@zope.org
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).

Robin Smidsr=F8d
Teknisk sjef

MobiLife AS   | Tlf:  +47 33334141 | Dir.:  +47 33334143
Kilengaten 1  | Fax:  +47 33334140 | Mobil: +47 91593393
3117 T=F8nsberg | post@mobilife.com  | robin@mobilife.com

Zope-DB mailing list