In your query output for the select, try this:
<CFOUTPUT QUERY="GetCounty" Group = "County">
<OPTION VALUE="#County#">#County#
</CFOUTPUT>
That should give you only one listing per county no matter how many
times it gets pulled out by the query.
Chris Montgomery
=========================================================
astutia.com -> http://www.astutia.com [EMAIL PROTECTED]
Astute e-business applications & web site development
210-490-3249/888-745-7603 Fax 210-490-4692
Allaire Consulting Partner/Authorized NetObjects Reseller
Find a Job in San Antonio -> http://www.sajobnet.com
Need professional help? -> http://www.psychadvisor.com
=========================================================
>-----Original Message-----
>From: LH Rothman [mailto:[EMAIL PROTECTED]]
>Sent: Monday, May 01, 2000 12:32 AM
>To: [EMAIL PROTECTED]
>Subject: List Box Search Question Cont...
>
>
>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.
------------------------------------------------------------------------------
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.
