I am providing a compound search option in a site that I am coding. The two
search choices are by County and Category.
I want to set the default option to "All" (all the counties) in the County
field.
For example:
<select name="County"
size="1">
<option value="*" selected>All</option>
<option value="Aberdeenshire">Aberdeenshire</option>
<option value="Anglesey">Anglesey</option>
<option value="Angus">Angus</option>
<option value="Antrim">Antrim</option>... etc
And my query code:
<cfquery name="getSearchResults" datasource="#application.database#"
dbtype="ODBC">
SELECT
tblCustomerDetails.CustomerID,tblCategories.CategoryID,CompanyName,County
FROM ((tblCustomer inner join tblCustomerDetails on
tblCustomer.CustomerID = tblCustomerDetails.CustomerID)
inner join tblCategories on tblCustomer.CategoryID =
tblCategories.CategoryID)
WHERE County = '#attributes.County#'
AND tblCustomer.CategoryID = #attributes.CategoryID#
ORDER BY CompanyName
</cfquery>
As you can see I have tried using a * as the first option in my <select>
tag, but unfortunately this does not work.
Does anyone have an idea how I can get this to work... many thanks in
advance.
David
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.