Connie, I thought of that, but couldn't get it to work properly. Mind sharing one of those queries?
That would save me some processing time! At 05:13 PM 4/5/2005, you wrote: >Or, apply the format in the query itself. I do something similar to get >just the month from the date. > > >-----Original Message----- >From: Ray Champagne [mailto:[EMAIL PROTECTED] >Sent: Tuesday, April 05, 2005 1:20 PM >To: CF-Talk >Subject: Re: Cfchart newbie ? > >I got my answer - CFCHART sucks. :) > >It seems that there is no way to format x-axis data using either cfchart or >cfchartseries. I had to be creative and loop through my query, changing >the value of each row to be a nicely formatted date. Ugly solution, but it >works. More info can be found in the comments section of this livedoc: > >http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a11.htm > >Just FYI, for anyone that might read this in the archives! > >Ray > >At 03:25 PM 4/5/2005, you wrote: > >I am making a simple line chart for the first time and I have run into an > >easy stumbling block that I can't seem to Google out. > > > >The Y-Axis are a series of prices, while the X-Axis is a series of > >dates. These are held in a DB. The problem that I am having is that the > >date always outputs on the X-Axis label as the SQL date, ie; 2005-05-05 > >00:00:00.0. No matter what I try, I can't get it to diplay as a simple > >date, like 05/05/2005. > > > >There has to be something I am missing here - I see a place to format the > >data for the Y-Axis, why not the X-Axis? I know that I can flip the chart, > >but I don't want to do that. > > > >Ray > > > >============================================= > >Ray Champagne - Senior Application Developer > >CrystalVision Web Site Design and Internet Services > >603.433.9559 > >www.crystalvision.org > >============================================= > > > >The information contained in this transmission (including any attached > >files) is CONFIDENTIAL and is intended only for the person(s) named > >above. If you received this transmission in error, please delete it > >from your system and notify us immediately. If you are not an intended > >recipient, please note that any use or dissemination of the information > >contained in this transmission (including any attached files) and the > >copying, printing, or retransmission of that information is strictly > >prohibited. You can notify us by return email or by phone at 603.433.9559. > >Thank you. > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201617 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
