Hello:
The list box on my search screen won't work. First, it lists ALL
counties (e.g., if "Ventura" is listed in 20 records then "Ventura" is
listed 20 times in the list box). Second, selecting a county returns a
result of ALL counties (e.g., if I select "Ventura" then BOTH "Ventura"
and "Los Angeles" display).
Any help would be TREMENDOUSLY appreciated.
Thanks,
Laura
<CFQUERY DATASOURCE="A2Z" NAME="GetCounty">
SELECT ID, County
FROM Property
ORDER BY County
</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="#ID#">#County#
</CFOUTPUT>
</SELECT>
</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.
