Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL code for inserting data based on a checkbox value
Hi all,
I am trying to insert data from two tables into specified table depending on the state of a checkbox.
I am using Oracle HTMLDB to do it. Below is the process for when the 'submit button' is pressed. I know it is definately wrong as it is missing some parts. Can anyone help?
For i in 1..HTMLDB_APPLICATION.G_F01.count
LOOP INSERT INTO "ATTENDANCES" ("STUDENT_ID", "REGISTER_ID") WHERE "STUDENT"."STUDENT_ID" = HTMLDB_APPLICATION.G.F01, AND "REGISTER"."REGISTER_ID" = :P201_REGISTER END LOOP
Thank you for you help
Shahram Received on Wed Apr 12 2006 - 10:43:34 CDT
![]() |
![]() |