Is there any way to use the dateformat function within cfgraph?
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
