Hey Alley, Try dumping the query <cfdump var="#qPageHitsReport #" /> to make sure that CF7 isnt doing anything funny with your query like renaming the columns.
Also make sure that you scope that variable so do #qPageHitsReport.PGE_ID# inside the url, see if that helps. Let me know, Rob -----Original Message----- From: ally mccluskey [mailto:[EMAIL PROTECTED] Sent: 23 April 2007 12:21 To: CF-Talk Subject: Problem with CFCHART Hi there, i'm having trouble upgrading some <CFGRAPH> code to <CFCHART> There seems to be some functionality removed which doesn't allow unique IDs to be passed to a URL. For example: In CF5 we have a page which graphs the Top 20 most viewed pages on our site. Each bar of the graph then links to that unique page when you click on it (ie. http://www.oursite.co.uk/page.cfm?ID=1234) IN MX, I cant figure out how to pass the unique ID (PGE_ID) of that query row to the URL attribute of <CFCHART> . Here is my Code: <CFQUERY name="qPageHitsReport" datasource="#Application.DSN#"> SELECT PGE_HITCOUNT, PGE_DESC, PGE_ID FROM ( SELECT PGE_HITCOUNT, PGE_DESC, PGE_ID FROM RGUDBA.WEBPAGE ORDER BY PGE_HITCOUNT DESC ) WHERE ROWNUM < 21 </CFQUERY> <CFCHART chartwidth="600" chartheight="500" title="Top 20 Pages by Page Views" format="png" URL="/general/info/page.cfm?pge=#PGE_ID#"> <CFCHARTSERIES type="horizontalbar" query="qPageHitsReport" itemcolumn="PGE_DESC" valuecolumn="PGE_HITCOUNT"> </CFCHARTSERIES> </CFCHART> With this code I get an error message: Error Occurred While Processing Request Variable PGE_ID is undefined. Is this not possible anymore? Surely Adobe havn't removed a really useful piece of functionality? ..... Or have they? Ally ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
