1 Reply Latest reply on Aug 23, 2007 7:14 PM by Newsgroup_User

    Sending multiple variables in chart url

    JoKnott Level 1
      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>