Inserting checkbox selections to an Access database 1

[Patt]

When I try to insert the selections into the table, multiple selections get put into one field. I would like multiple selections to each be a record in the table.

 

[slok]

before u insert into the table...<br>
u can do somekind of 'split' function to <br>
split the string into different variables.<br>
<br>

 

[jwoody]

If your question has not yet been answered...<br>
<br>
You need to loop through the list. I created a series of checkboxes with a vlue of the primary key...<br>
<br>
Then on the action page, loop through them and perform your desired action...<br>
<br>
This will loop through all checkboxes named approve and simply output AID each time. Your action will be an insert up update or whatever...<br>
<br>
&lt;cfloop index="AID" list="#approve#"&gt;<br>
<br>
&lt;CFOUTPUT&gt;<br>
#AID#<br>
&lt;/CFOUTPUT&gt;<br>
<br>
&lt;/cfloop&gt;<br>
<br>
Hope this helps,<br>
Jon