[Zope] CheckBoxes, dynamic lists and SQL insert statements

15 Jul 2003

      Hi all,
I'm feeling rather thick, as I've been reading through some of a similar question from about 2 years back 

( http://mail.zope.org/pipermail/zope/2001-August/097408.html ) 

and I'm not quite understanding it.

What I am trying to achieve is to pull some date from one table by an SQL query, and have the results selectable/de-selectable by the form of a checkbox - to then be dumped into a temporary table.

I'm guessing that it's probably something simple, and I'm just too close to the code.

This here is my selection via checkbox form.. this seems to pass the information to my next step ok...
I believe that I have a problem with how I am interpreting this data.

<!-- form 2 -->
<form action="meth_step_2" name="form2">
<table>
  <!--#in dealer_entity_search -->
      <tr>
    <td>
          <input type='checkbox' name='marketinglist:list' checked value='<!--#var dealer_code -->'></input>
          <!--#var dealer_code --></td>
   <td><!--#var dealer_name --></td>
     </tr>
  <!--#/in --><TR><TD><button type="submit">Add</button></TD></TR>
  </form>
</table>

<!-- meth_step_2 -->
<!--#with sql -->
    <!--#in marketinglist -->
      <!--#let dealer_code=sequence-item -->
        <!--#call insert_holding_table -->
      <!--#/let -->
    <!--#/in -->

<!--#/with -->

<!-- insert_holding_table -->
insert into mHoldingTable
(
dealer_code
)
values
(
<dtml-sqlvar dealer_code type="string" >
);

What I am wanting to appear in the holding table is a whole lot of separate records, each containing only a dealer_code (which is a 4 digit integer - text field in the DB though) 
I'm using Zope 2.3.3 attempting to inserting into MS Access 2000.

Thanks in advance.
______________________________________________________
______________________________________________________
Julian Clark 
julcla@b-online.com.au 
Ph: +61 8 9463 5069 
______________________________________________________