Hey there, I have the following code that works just fine, but I would like for it to filter/search through another category.

"SELECT SupplierName, Location, ShortDescription, TimberSpecies, CategoryTitle, Country
FROM Query1
WHERE TimberSpecies LIKE '%" + Replace(rsSearchResult__MMColParam, "'", "''") + "%' AND CategoryTitle LIKE '%" + Replace(rsSearchResult__MMColParam2, "'", "''") + "%' AND Location LIKE '%" + Replace(rsSearchResult__MMColParam3, "'", "''") + "%'
ORDER BY SupplierName"

In this code I would like for the search to also search all customers with the "Retail-Trade" category. "Wholesale" I want to exclude.

Table Name: Query1
Column Name: BusinessType
Record or Category Names: Retail-Trade & Wholesale.

Is this possible with the code I have supplied?

Thanks again.

Mally.

Hi Mally,

You can use the OR operator in your code, like this:

SELECT SupplierName ..... FROM Query1 WHERE CategoryTitle LIKE
        '%SomeValue%' OR CategoryTitle LIKE '%SomeOtherValue%'

This should return records where the CategoryTitle contains either SomeValue or SomeOtherValue (or both)

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks Imar, yest it did help.

Mally

So how would you go about coding on a recordset to ignore a drop-down menu if nothing is selected so no data is shown and still show data from the other combo menus base on what was selected?

Thnks

Hi sunvalley,

Can you please start a new thread when you post a question not related to the initial question? Makes it easier for everyone to find and manage this thread.

That said, can't you create a WHERE clause dynamically based on what is selected??
E.g.

sqlWhere = " WHERE SomeCondition"
If Request.Form("SomeDropDown") <> "" Then
  sqlWhere = sqlWhere & " SomeField = " % Request.Form("SomeDropDown")
End If

If Request.Form("SomeOtherDropDown") <> "" Then
  sqlWhere = sqlWhere & " SomeOtherField = " % Request.Form("SomeDropDown")
End If


This way, you effectively ignore the drop downs that don't have a value.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004