if you use checkboxes for the selections, use isDefined() on your action
page. if the checkbox for that selection is defined, include it in your
where clause
ex:
SELECT
....
WHERE
....
<CFIF isDefined("FORM.hottub")>
AND <hottub field is yes>
</CFIF>
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-----Original Message-----
From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 1:31 PM
To: CF-Talk
Subject: How to Allow a "Doesn't Matter" Variable in a Search?
Friends: Can anyone help with this problem I'm stuck on? Not sure if this
is a simple one or not, but in any case I'll sure be delighted to get it
working.
This set of pages allows the user to search a set of records using 9 search
objects. Four of those are for searching yes/no (1/0) fields in the
Access2000 database.
For the four search fields which search yes/no columns, I want them to
choose either "This doesn't matter - don't include this in the search" OR
"Include only records with "yes" (1) in this column. They need to be able to
specify that they want to see only rental properties that have a hot tub, or
else that this doesn't matter to them.
Obviously this differs from offering the choice between "Include only
records with 'yes' in this column" and "Include only records with 'no' in
this column", which is *not* what I need to do here.
This could be done with checkboxes or a menu - but I can't figure out how to
allow that "This doesn't matter" search parameter.
Thanks very much in advance for your help!
P@tty Ayers
Macromedia Evangelist
Dreamweaver Resources, FAQs, and Tutorials:
http://www.thepattysite.com/dreamweaver/
P@tty's ColdFusion Site
http://carolina.cf-developer.net
Carolina Web Solutions
http://www.carolinawebsolutions.com
"Design in art, is a recognition of the relation between various things,
various elements in the creative flux. You can't invent a design. You
recognise it, in the fourth dimension. That is, with your blood and your
bones, as well as with your eyes." - D. H. Lawrence
"Well-behaved women seldom make history." - Anonymous
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
