Why don't you make the query join these two related tables through the key column of "DEFECT_CODE" and select both columns? then,
<cfchart chartwidth="350" chartheight="250" caleFrom=0 scaleTo=50 show3d="yes"> <cfchartseries type="PIE" query="getresult" itemColumn="DEFECT_CODE" valueColumn="DC"/> <cfchartseries type="PIE" query="getresult" itemColumn="defect_description" valueColumn="DD?"/> </cfchart> Now, another thing, is chart normally used to display long description? Li, Chunshen (Don) http://68.32.61.40/datadata/dataman.cfm >hi.. i would like to know if anyone could help me with my problem.. > ><cfchart chartwidth="350" chartheight="250" caleFrom=0 scaleTo=50 >show3d="yes"> ><cfchartseries type="PIE" query="getresult" itemColumn="DEFECT_CODE" >valueColumn="DC"/> ></cfchart> > >You see, defect_code is stored in one table while I want to display >the defect_description which is in another table. I would like to >know how to change the defect_code to defect_description. defect_code > >is the main link between the 2 tables. > >Thanx in advance..! :) > > > > >--------------------------------- >Do you Yahoo!? >Yahoo! SiteBuilder - Free, easy-to-use web site design software ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
