On your propsrch1.cfm page, when you're selecting the records to display,
you could include something like this in your query
<cfquery datasource="A2Z" name="selectRecordsToDisplay">
select * from property where 0=0
<cfif form.acres is 1> and (acres >= 1 and acres <= 5)
<cfelseif form.acres is 2> and (acres >= 6 and acres <= 10)
<cfelseif form.acres is 3> and acres >= 11</cfif>
</cfquery>
It's a bit of a hack, but it'll work.
Josh
----- Original Message -----
From: "LH Rothman" <[EMAIL PROTECTED]>
To: "CF Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 01, 2000 12:01 PM
Subject: Checkbox Search Within Range
> Hi!
>
> How do I search within a numeric range? For example, I want to be able
> to use checkboxes to search by 1-5 or 6-10 acres. My database contains
> both whole and fractional amounts.
>
> Thanks for any help!
> -Laura
>
>
> <CFQUERY DATASOURCE="A2Z" NAME="GetCounty">
> SELECT DISTINCT County
> FROM Property
> </CFQUERY>
>
> <HTML>
> <HEAD>
> <TITLE>Property Search</TITLE>
> </HEAD>
> <BODY>
>
> <P><FONT FACE=ARIAL SIZE=4>Property Search</FONT></P>
>
> <FORM ACTION="propsrch1.cfm" METHOD="POST">
>
> <FONT FACE=ARIAL SIZE=2>
> APN: <INPUT TYPE="text" NAME="APN"><BR>
> Parcel ID: <INPUT TYPE="text" NAME="ParcelID"><BR>
> County:
> <SELECT NAME="County">
> <OPTION>
> <CFOUTPUT QUERY="GetCounty">
> <OPTION VALUE="#County#">#County#
> </CFOUTPUT>
> </SELECT>
> <BR>
> Acres:<BR>
> <INPUT TYPE="radio" NAME="Acres" VALUE="1">1-5<BR>
> <INPUT TYPE="radio" NAME="Acres" VALUE="2">6-10<BR>
> <INPUT TYPE="radio" NAME="Acres" VALUE="3">11+<BR>
> </FONT>
>
> <P>
> <INPUT TYPE="submit" VALUE="Search">
> <INPUT TYPE="reset" VALUE="Clear">
>
> </FORM>
>
> </BODY>
>
> </HTML>
>
>
>
>
>
> --------------------------------------------------------------------------
----
> 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.
