[Zope-DB] Batch update mode

[Chan YH]

I phrased my question wrongly in my previous email and wished to thanks
those who replied.

I am trying to insert/update a table in a batch mode.
The coding below is a simplified version.

What I wanted to do is to INSERT/UPDATE a table (contact ) in a BATCH  mode.
The user will see a form listing (company) and select the option from  table
(person).

Upon completion, the user a submit the matched listing to be inserted in
another table (contact).

I need some help  in doing this in a BATCH mode.

For e.g.  if I have 10 companies with the selected persons in a batch
to be inserted into contact table.

  Company name        Person
  (company table)          (person table)
 ----------------        --------
1. company A           Chan
2. company B           Henry
...
10. company X          Robert

insert/update batch to contact table.

Could someone give me some guidance?


TQ


Data Entry Form
============
<dtml-var standard_html_header>
<h2><dtml-var title_or_id></h2>
<form method="post" action="form2_action" enctype="multipart/data">
<table>
   <dtml-in listCompany_sql>
      <tr>
         <td>Company:</td><td><dtml-var co_name></td>
         <td><select name="last_name" value="">
                   <dtml-in listPerson_sql>
                      <option
value="&dtml-last_name;">&dtml-last_name;</option>
                   </dtml-in listPerson>
             </select>
          </td>
      </tr>
   </dtml-in listCompany>
   <tr>
      <td><input type="submit" value="Submit" name="submit" /></td>
   </tr>
</table>
</form>
<dtml-var standard_html_footer>

SQL methods
==========
listCompany_sql
-----------------
select * from company

listPerson_sql
-------------
select * from person

 CREATE TABLE contact
(
 first_name        char(20),
 last_name         char(20),
 co_name           char(20),
 co_phone          char(20)
 );

CREATE TABLE person
(
name_id           int PRIMARY KEY,
first_name        char(20),
last_name         char(20)
);

CREATE TABLE company
(
co_id              int PRIMARY KEY,
co_name         char(20),
co_phone        char(20)
);