IMHO, it would be a lot simpler to just do them as select boxes w/ a
default of no. This way you can just loop through the list w/ one query.
Then again 237 is a lot to loop through OR to answer... Tried breaking
this up?
At 05:21 PM 3/29/00 -0500, 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.
>
ATTN.
Mario Talavera
NetPassage, Inc.
419 N. Magnolia Avenue
Orlando, Fl 32801
407.843.7277
888.296.7277
407.839.0126 (fax)
http://www.netpass.com
[EMAIL PROTECTED]
------------------------------------------------------------------------------
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.