Yes.

You need to create your form and your checking via a loop.  Anytime you have
more than say 5 lines of something redundant I use a loop.  No use wasting
time hardcoding all that when you can make it changeable very quickly by
just changing the loop parameters with possibly a variable you pass it or a
query attribute.

Look into CFLOOP's:  no programmer in his right mind will write all that out
without a loop.



Michael W. Blair

Web Applications Developer
Canyon WebWorks
An Arizona Internet LLC Company
http://www.canyon.net
[EMAIL PROTECTED]
PHONE: (520) 773-9059
FAX:   (520) 773-4945

-----Original Message-----
From: Daniel Murphy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 3:22 PM
To: '[EMAIL PROTECTED]'
Subject: 237 checkboxes

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.

Reply via email to