I wonder who is filling out the 237 question survey, and whether they're
getting paid! ;-) Have you considered creating some sort of "profile" to
search the survey results by? It'll take just as long to harvest the data as
it did to fill it out! And imagine selecting your options all the way down
the form, and then returning no results?! ;-)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 30, 2000 9:41 AM
To: [EMAIL PROTECTED]
Subject: Re: 237 checkboxes
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.
------------------------------------------------------------------------------
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.
