APEX

Hi,

I am having a problem with popup window and url link in flash chart and hoping someone can help me with this.

Below is my select statement for the flash chart, and I want to be able to click on any device type on the chart which will popup a window with a more detail report of that device type.

select 'javascript:popupURL("f?p=&APP_ID.:18:&APP_SESSION.::::P19_DEVICE_TYPE:") || DEVICE_TYPE' as link, DEVICE_TYPE label, COUNT(SEQ_NO) value1
from PSWSC_WIRELESS
where SURPLUS = 'NO' and
LOCATION_AREA is not null
group by DEVICE_TYPE
order by DEVICE_TYPE

When running this, I got an error on page 19 "error: 'DEVICE_TYPE' is undefined. And no data found on page 18.

I had also looked at the link below, but still doesn't work.

http://forums.oracle.com/forums/thread.jspa?messageID=3854974&#3854974

I would appreciate any help from you all.

Thank you so much,
MT