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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
