PL/SQL code for inserting data based on a checkbox value

#1

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

#2

shahram.shirazi (AT) gmail (DOT) com wrote:

Quote:

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...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

PL/SQL code for inserting data based on a checkbox value

comp.databases.oracle.misc comp.databases.oracle.misc

PL/SQL code for inserting data based on a checkbox value - 04-12-2006 , 11:43 AM

Re: PL/SQL code for inserting data based on a checkbox value - 04-12-2006 , 01:42 PM