Working with APEX_APPLICATION.GFXX
550387Jan 16 2007 — edited Jan 17 2007Hello,
I have created a series of checkboxes on my page. When the page is submitted I loop through the apex_application.GF01 array to see which of check boxes has been set.
------
FOR I in 1..APEX_APPLICATION.G_F01.COUNT LOOP
update mytable set status = 'CHECKED' where my_id = to_number(APEX_APPLICATION.G_F01(i));
END LOOP;
-----
I would like to be able to also update the table based on what is not on the list, so would like to do something like this;
------
update mytable set status='UNCHECKED' where my_id not in ( select <INSERT ALL VALUES FROM ARRAY> from dual);
------
Can somebody please guide me on how to select out of this array... do I just need to create another type and select out of that, or is there a simple way that I am unaware of.
Thanks
Ben