You could modify your query object before sending it to <CFGRAPH>.
EXAMPLE:
<cfquery name="graphData" datasource="#Application.DSN#">
SELECT Date, Value
FROM TableName
ORDER BY Date
</cfquery>
<cfloop query="graphData">
<cfscript>
QuerySetCell(graphData, "Date", DateAdd("h", 2, graphData.Date),
graphData.CurrentRow);
</cfscript>
</cfloop>
HTH ^_^
--
SCOTT VAN VLIET
SENIOR ANALYST
SBC SERVICES, INC
Tel: 858.886.3878
Fax: 858.653.6763
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 12:01 PM
To: CF-Talk
Subject: dateadd with grouped query and cfgraph
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?
Thanks!
Jeff
______________________________________________________________________
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
