Boo Hoo!
Make the following changes and I think you can get there:
(The label will say 500, rather than the more proper 500-1000, but I leave that as a detail for you to finish)
=)
Jerry Johnson
<cfif IsDefined("URL.Chart") AND url.Chart EQ "6">
<cfset ChartMe="ElevationGain">
<cfset ChartMeCalc="integer(ElevationGain/500)*500">
<cfset Title="Elevation Gained In Feet PieChart">
</cfif>
<!--- End Catch block for URL variables --->
<cfparam name="ChartMeCalc" default="#ChartMe#">
<cfquery name="Recordset1" datasource="hike">
SELECT #ChartMeCalc# as #ChartMe#, count(*) as Chart_count
FROM hike
Where #ChartMe# is not null
group by #ChartMeCalc#
order by #ChartMe#;
</cfquery>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]