Didn't work. Any other ideas?
-L
Chris Montgomery wrote:
> 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.
------------------------------------------------------------------------------
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.