shahram.shirazi_at_gmail.com wrote:
> 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
>
Search the oracle htmldb forum - this is one of the faqs there.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Apr 12 2006 - 12:42:20 CDT
