The problem is in the form's action page, propsrch1.cfm. Can you show it
to us?
-David
On Sun, 30 Apr 2000 23:18:47 -0700 LH Rothman <[EMAIL PROTECTED]> writes:
> 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.
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
------------------------------------------------------------------------------
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.
