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 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276002
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to