Hi!
The list box on my search screen doesn't work. Regardless of the county
I select, it displays ALL counties. Can someone please take a look at
my query and option value stuff? (BTW - other search items work fine.)
Thank you!
-L
<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>
</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.