My items are dates which display as an ugly odbc date with the time included.
Trying to add a dateformat throws an error. What am I missing? I tried with and
without #'s and with
and without double "" and single '.... can't find any combination that will work.
This code works fine:
<cfgraph type="BAR"
query="logonsbydate"
valuecolumn="logoncount"
itemcolumn="date_in"
barspacing="20"
url="logons.cfm?showdate="
urlcolumn="date_in">
</cfgraph>
This code will not:
<cfgraph type="BAR"
query="logonsbydate"
valuecolumn="logoncount"
itemcolumn="date_in"
barspacing="20"
url="logons.cfm?showdate="
urlcolumn="dateformat(date_in,'m/d/yy')">
</cfgraph>
The error is very non descript
Error Occurred While Processing Request
Error Diagnostic Information
CFGRAPH
The error occurred while processing an element with a general identifier of
(CFGRAPH),
occupying document position (34:1) to (40:52) in the template file C:\MY
DOCUMENTS\CHRIS
DATA\WEBSITES\PEOPLE IN MAMMOTH PRODUCTIONS\ADMIN\LOGONS.CFM.
Date/Time: 08/24/01 19:08:16
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Remote Address: 127.0.0.1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists