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

Norman Khine norman@khine.net
Fri, 7 Mar 2003 10:43:47 -0000


http://www.devshed.com/Server_Side/MySQL/MySQLWiz/print_html

should be helpful

-----Original Message-----
From: Robin Smidsr=F8d [mailto:robin@mobilife.com]
Sent: 07 March 2003 10:25
To: 'Norman Khine'
Subject: RE: [Zope-DB] Creating a "matrix" HTML table from a database
table


Could you show me an example of this inner join you're suggesting?

> -----Original Message-----
> From: Norman Khine [mailto:norman@khine.net]
> Sent: 7. mars 2003 11:07
> To: Robin Smidsr=F8d
> Cc: zope-db@zope.org
> Subject: RE: [Zope-DB] Creating a "matrix" HTML table from a
> database table
>
>
> 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 actual
> product.
>
> you'll probably need a 3-d graph, where x-axis is the date,
> y-axis will be
> 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
>