Thanks for the suggestion but I'm a newbie and can't figure out how/where to insert
that code. Here is PROPSRCH1.CFM. Any help would be appreciated.
-Laura
<CFQUERY DATASOURCE="A2Z" NAME="Property">
SELECT ParcelID, APN, County, Acres, ID
FROM Property
WHERE 0 = 0
<CFIF ParcelID IS NOT "">
AND ParcelID LIKE '#ParcelID#%'
</CFIF>
<CFIF APN IS NOT "">
AND APN LIKE '#APN#%'
</CFIF>
<CFIF County IS NOT "">
AND County LIKE '#County#%'
</CFIF>
<CFIF Acres IS NOT "">
AND Acres LIKE '#Acres#%'
</CFIF>
ORDER BY ParcelID
</CFQUERY>
<HTML>
<HEAD>
<TITLE>Property List</TITLE>
</HEAD>
<BODY VLINK=Black>
<P><CENTER><FONT FACE=ARIAL SIZE=4><B>
<CFOUTPUT>Found #Property.RecordCount# matches</CFOUTPUT>
</b></font></CENTER>
<P><CENTER>
<TABLE BORDER=2 CELLPADDING=5>
<CFOUTPUT QUERY="Property">
<TR>
<TD BGCOLOR=FAFAD2><FONT FACE=Arial SIZE=2>Parcel ID: <CFIF Len(Trim(ParcelID)) IS 0>
N/A</CFIF> <A HREF="propdt.cfm?ID=#ID#">#ParcelID#</A>,
APN: <CFIF Len(Trim(APN)) IS 0>
N/A</CFIF>#APN#, #County# County, #Acres#</FONT>
</TD>
</TR>
</CFOUTPUT>
</TABLE>
</CENTER>
</P>
</BODY>
</HTML>
Josh Black wrote:
> 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.
------------------------------------------------------------------------------
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.
