> As you can see I have tried using a * as the first option in my <select>
> tag, but unfortunately this does not work.
Well, firstly you would want "%" instead of "*". Secondly, why not simply
chop out the WHERE... if you want all counties -- more efficient SQL.
<select name="County" size="1">
<option value="" selected>All</option>
.
.
.
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
<cfif attributes.County GT "">County = '#attributes.County#' AND</cfif>
tblCustomer.CategoryID = #attributes.CategoryID# ORDER BY CompanyName
------------------------------------------------------------------------------
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.
