Optionally, you can name them all the same, assign them different
values...any that are checked will have their values passed as a list. That
way you only have 1 <CFPARAM> to worry about.
> I have search form that contains a large amount of yes/no check boxes -237
> to be exact. It is to search the results of a survey that has 237
questions.
>
> Only when a checkbox is checked will data be sent from the form. Because
of
> this I need to check if each variable is present. I can create 237 "CFIF
> IsDefined" statements to see if the variables are present. The other
option
> is to set 237 CFPARAM variables to "NO" as default, and then create my
> dynamic SQL statements with CFIF tags checking for "YES".
>
> The problems with these two options is that they are slow and will take a
> long time to code.
>
> 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.
>
> Thanks, Dan
> --------------------------------------------------------------------------
----
> 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.
>
------------------------------------------------------------------------------
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.