Hi all,
I'm feeling rather thick, as I've been reading
through some of a similar question from about 2 years back
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.