Insert Records from checkboxes

[roshea]

Hi,

I would like to be able to insert multiple records into a database using
checkboxes.

A query is used to display the checkboxes.

How can I insert data into a table when a user selects multiple checkboxes?


Thanks
Roslyn



<cfloop query="Query1">
<cfinput type="Checkbox" Name="Test_#Query1.ID#" label="#Query1.Name#">
</cfloop>

[blewis]

If you are using distinct names for each checkbox, then you need to run the
same query on the processing page and loop through them looking for a value.
Remember that checkboxes are not defined if they are not checked. One thing
you may want to check on in your code is that these checkboxes have no value.
You will want to add that.

So do this:



<cfloop query="Query1">
<cfif isDefined("form.Test_#Query1.ID#")>
<cfquery name="myQuery" ...>
INSERT INTO myTable
(ID, value)
VALUES( #Query1.ID#, #Evaluate("form.Test_" & Query1.ID)#)
</cfquery>
</cfif>
</cfloop>