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

[Norman Khine]

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=
al
product.

you'll probably need a 3-d graph, where x-axis is the date, y-axis will b=
e
the accumulated count, and z-axis the product_id!

then you should be able to pull your data using inner join statement and =
get
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
call.
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).


Mvh,
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
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db