Have you tried using "%" instead of "*"
- (I think * is the wildcard charachter in access, and % in SQL Server...)
On Fri, 04 August 2000, David Crowther wrote:
>
> 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.
___________________________________________
It's amazing what happens when you breathe.
www.breathe.com
------------------------------------------------------------------------------
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.
