Matthew... you ARE the man!
That worked great... thanks for helping me out.
David
-----Original Message-----
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: 04 August 2000 11:26 AM
To: [EMAIL PROTECTED]
Subject: RE: <select> and defaulting to "All"
> 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.
------------------------------------------------------------------------------
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.
