DBD::Chart is definitely the way to go - it's very neat. I did run into some problems and it was hard to debug (DBI's RaiseError and trace() don't really help when INSERT'ing bad data into the chart table), but with help from some Dumper()'s and die()'s, I was able to track it down to problem with one of my regex's.
I also took Cees' input about data changing and Mark's input about using the src attribute to wrap it up.
I put up a (hopefully) safe version of my code online so you can how I did it (if you're interested). URL's below.
You know, one interesting thing about my cgiapp's these days is that there's about 100 lines of code before I'm actually putting any runmodes together, between the setup, the cgiapp_init w/ LogDispatch settings and an error_mode.
Another annoying thing about my web server setup is that whenever it writes files (logs, trace files, Storable files, etc), it's owned by the server process (www-data) and in mode 0600, so when I'm logged in and trying to read 'em, I gotta chmod it, be root, or something. So that's why I have chmod's sprinkled in that code. There's prolly a umask setting somewhere... just haven't gotten around to it.
Lastly, I'm trying to figure out how to have DBD::Chart enforce only whole numbers on the X axis (Day 27.3? ;)). But as my dataset grows, it will become less of a problem.
Thanks everyone for the help and I still welcome input/advice. :)
- Jason
URL's:
CGI::App Module:
http://purdy.info/useperl/InteractiveReport_safe.pm.html
H:T Template:
http://purdy.info/useperl/report.TMPL
Screenshot:
http://purdy.info/useperl/InteractiveReport_Sample.html
---------------------------------------------------------------------
Web Archive: http://www.mail-archive.com/suppressed/
http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
To unsubscribe, e-mail: suppressed
For additional commands, e-mail: suppressed
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.