Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL code for inserting data based on a checkbox value

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

From: <shahram.shirazi_at_gmail.com>
Date: 12 Apr 2006 08:43:34 -0700
Message-ID: <1144856614.249082.224860@e56g2000cwe.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US