> I run a graph on a server in a different time zone. I'd like > to modify the times (hour only) by adding two hours. However, > the query is grouped by day and hour, then fed into CFGRAPH. > > Anyone know if this can be done without modifying the data in > the table?
You could modify the data in the query object, after running the query, using QuerySetCell and the other query functions. You could even use the query-of-query functionality to do the same thing with SQL. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
