Newbie question: selecting and displaying rows based on boxes checked
666835Oct 23 2008 — edited Oct 24 2008I'm displaying a report region with two columns from a departments table followed by a checkbox on each line
SELECT apex_item.checkbox(1,DEP_ID,'UNCHECKED') " ",
DEP_ID,
DEP_NAME
FROM Departments
I've got a button named SUBMIT
and a process named OnSubmit (On submit after computations and validations)
I'm trying to make the checkboxes select departments based on DEP_ID and then to display the entire corresponding row from the Departments table in a second report region below the first one. I've tried any number of versions of PL/SQL in the process Source but either I get an error or nothing happens... Could someone help?
I've tried to adapt all the tutorials I can find on the subject of checkboxes but to no avail...