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