Try SELECT DISTINCT
----- Original Message -----
From: "LH Rothman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 30, 2000 10:08 PM
Subject: List Box Search Question
> 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.
------------------------------------------------------------------------------
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.
