APEX

hi all,

i've been reading about how to add check boxes to SQL Reports (instead of using Tabular Forms). i was able to add a checkbox by using SELECT apex_item.checkbox(pk,1)... although i'm not entirely sure what the arguments (pk,1) are but anyways this works. now i have to create a process that gets the data for the 5th column. if i had a query like

SELECT apex_item.checkbox(employee_id,1)
              employee_id,
              last_name,
              first_name,
              middle,
              email_address
   FROM employees;

i want to pass the values of the email_address to an Item on my page. i have tried the following codes but it doesn't work somehow.

DECLARE
BEGIN
FOR i in 1..APEX_APPLICATION.G_F01.count
LOOP
 IF APEX_APPLICATION.G_F05(i) IS NOT NULL THEN
   :P3_EMAIL_ADDRESSES := :P3_EMAIL_ADDRESSES || '; ' || APEX_APPLICATION.G_F05(i);
 END IF;
END LOOP;
END;

this process is invoked by a button "Email". then i have one unconditional branch the branches to the same page.

it doesn't pass the value to my item. and i don't get any error messages in APEX but sometimes i get the http 404 page.

please help.

thanks
allen

Message was edited by:
A.Sandiego