macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Re: Turning a List Into A Query

Subject: Re: Turning a List Into A Query
From: "cf_dev2"
Date: Fri, 24 Aug 2007 18:55:05 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
I don't see what's so horrid, aside from the fast food.

 You need to add a title column but this is straight from the example.  

 <cfset myQuery = QueryNew("")>
 <cfset FastFoodArray = ArrayNew(1)>
 <cfset FastFoodArray[1] = "#PercentOnTime#">
 <cfset FastFoodArray[2] = "#PercentWeekLate#">
 <cfset FastFoodArray[3] = "#PercentReallyLate#">
 <cfset nColumnNumber = QueryAddColumn(myQuery, "FastFood", FastFoodArray)>
          
 <cfchart 
       tipStyle="mousedown" 
       font="Times"
       fontsize=14
       fontBold="yes"
       backgroundColor = "##CCFFFF"
       show3D="yes"
       >
       
    <cfchartseries 
       type="pie" 
       query="myQuery" 
       valueColumn="FastFood" 
       colorlist="##6666FF,##66FF66,##66CCCC"
       />
 </cfchart>       




<Prev in Thread] Current Thread [Next in Thread>