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.