Sending multiple variables in chart url

[JoKnott]

HI, I have aseries of charts where users can drill down into the data. That's fine.
The problem is the first graph is based on users form selections, which are used in the chart query as url variables. How do I then pass those variables when I drill down into the chart using cfchart url????
Hope that's clear. Code below
Thanks
<cfquery name="Domicile" datasource="MI" maxrows="20">
select count([06Student]) as stucount, domicileDesc
from tbl_StudentRecord, tbl_People, LUtbl_Domicile, LUtbl_FeeStatus, IMPtbl_Programmes
where tbl_StudentRecord.[06PersonNo] = tbl_People.PersonNo
and tbl_People.Domicile = LUtbl_Domicile.DomicileCode
and tbl_StudentRecord.[06FeeStatus] = LUtbl_FeeStatus.FeeStatus
and tbl_StudentRecord.[06Programme] = IMPtbl_Programmes.Programme
and Faculty in ('#url.fac#')
Group by DomicileDesc
ORDER BY count([06Student]) DESC
</cfquery>


<cfchart chartwidth="700" chartheight="400" url="school/Filter_All_Domicile_Sch.cfm?item=$itemlabel">
<cfchartseries type="bar" query="Domicile" itemcolumn="DomicileDesc" valuecolumn="stucount" ></cfchartseries>
</cfchart>

[Newsgroup_User]

iirc, just like you normally would with any url variable: by appending
it to the url
in your case that would be the url attribute of cfchart tag:

url="school/Filter_All_Domicile_Sch.cfm?item=$itemlabel$&faculty=#url.fac#
--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com