Thanks works great, the below is the code, Now I can join query to  pull data in more detail.

<cfquery name="stats" datasource="#DSN#">
select dealer,
  count(id) as adcount
from dealerAds
group by dealer
</cfquery>
<cfdump var="#stats#">

<cfchart format="Flash" title="Stats Report" xaxistitle="Dealers" yaxistitle="Ads created" chartheight="500" chartwidth="600" showlegend="yes" labelformat="number">
<cfchartseries type="bar" query="stats" itemcolumn="dealer" valuecolumn="adcount"></cfchartseries>
</cfchart>


>table layout, and a little better explanation?
>
>
>On Mon, 13 Sep 2004 11:03:57 -0400, Asim Manzur
><[EMAIL PROTECTED]> wrote:
>>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to