>I was thinking:
>
>Is there a way to create a loop that will run through all the values from
>the form - creating a query and output for each one.
If your questions are all numbered sequentially then this is real easy.
Name your checkboxes something like "Question_x" where "x" is the question
number. Then...
<!--- action_page.cfm --->
<CFLOOP INDEX="i" FROM="1" TO="237">
<CFIF IsDefined("Form.Question_" & i)>
<!--- question was checked --->
<CFELSE>
<!--- question was not checked --->
</CFIF>
</CFLOOP>
If your questions aren't numbered sequentially then you have to modify this
slightly. You will need a list of all the question numbers that are on the
form (such as "1,3,4,5,9,11"). Assuming that the list of numbers is in
lstNumbers you can do:
<!--- action_page.cfm --->
<CFLOOP INDEX="i" LIST="#lstNumbers#">
<CFIF IsDefined("Form.Question_" & i)>
<!--- question was checked --->
<CFELSE>
<!--- question was not checked --->
</CFIF>
</CFLOOP>
If you have non-sequential question numbers and need help figuring out how
to build the list of numbers let me know.
Hope this makes sense,
Seth Petry-Johnson
Argo Enterprise and Associates
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.