Hello, I'm trying to utilize ZGDChart to make some graphs of data from a PostgreSQL database. The website users go through 1 to 3 pages of forms to specific what data they want a report on and then the numbers are generated in the final action DTML method. I really want to have a graph on that page and so far have found ZGDChart as a tool. Unfortunately it looks to me like none of the data methods work for my situation: DTML-method : the method in the chart needs to receive variables to get the data, I can't find a way to pump them in Tiny Table: If I could insert data into a TinyTable with my final method action it would work, But that doesn't appear to be how TinyTable works ZSQL Query: need to pass variables into the query. It's not a vanilla lookup but a calculation too. Python Script: Can't say I know enough about python to try, but it looks like I'd run into the same variable problems. Any suggestions? Any other products out there for generating graphs in Zope? thanks, Scott
We use Postgres & ZGDChart for graphic. You almost certainly want to be using ZSQL Queries. You can easily pass variables into a ZSQL query and do any calculations that you need - either in the SQL itself or in the DTML within the method. If you post some more details to the list about what exactly you are trying to do I'll give a more precise answer. A -- Logical Progression Ltd, 16 Forth Street, Edinburgh EH1 3LH, UK Tel: +44 (0)131 466 9585 Web: http://www.logicalprogression.net/
ZSQL Query: need to pass variables into the query. It's not a vanilla lookup but a calculation too. Python Script: Can't say I know enough about python to try, but it looks like I'd run into the same variable problems.
Sure thing. It's a web interface to a database for analyzing test scores. Each test may test on 1 or more 5 "objectives" of the academic program. Here's how a simple report goes Pages 1 & 2 are forms. Page 1: User choose year of class (classyear) and year of assessment (testyear). [Submit] Page 2: ZSQL query lists tests for that class and year. User picks the test they want a report on (test_id). [Submit] Page 3: Displays a table of min / max / mean scores of nonzero objectives for the test through ZSQL calls -- passing test_id, classyear, and objective name. How do I pass the form variables into the DTML used by ZDGChart? Thanks, Scott
We use Postgres & ZGDChart for graphic. You almost certainly want to be using ZSQL Queries. You can easily pass variables into a ZSQL query and do any calculations that you need - either in the SQL itself or in the DTML within the method.
If you post some more details to the list about what exactly you are trying to do I'll give a more precise answer.
participants (2)
-
Andrew Veitch -
Scott Krajewski