add a
WHERE clause
to your query
At 10:32 PM -0700 4/30/2000, LH Rothman wrote:
>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_tal
>k 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.
