I think you need to reconsider your form design altogether.
I think your HTML page (ie the one with the form) is going to lock up or
simply flake out trying to render 237 checkboxes.
Tobe
At 05:21 PM 3/29/2000 , you wrote:
>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.
