Keyword Search Problem

Hi guys,

I'm having a small problem with a keyword search not functioning correctly.

Here's the scenario .... I'm using ASP in DWMX, with Access 2000 and am simply using a multiple search page where the user can select various options or just one option. One of these boxes is a keyword box named 'Des' (for description) This is named the same in the database.

On the results page I have a recordset and have set up my variables. One variable is called sSchool which refers to simply a drop down on the search page and the other is the sDes variable which refers to a text box for entering keywords. The variable code for the keyword field is ...

name = sDes
default value = %how%
runtime value = request.form("Des")

My SQL in the advanced box is....

SELECT *
FROM Links
WHERE Des LIKE 'sDes' AND School LIKE 'sSchool'

I have tried modifying this, mainly in the default value column i.e. just having % but still no luck.

The School bit works fine, just not he keyword bit.

Any ideas where I'm going wrong??

Any help would be much appreciated as I've spent hours!!!

Appologies if this is slightly in the wrong forum area, but wasn't quite sure where best to put it.

Thanks in advance

Jon

not sure about access 2000, but in access 97 the wildcard character is the asterisk

see also http://www.devguru.com/features/kno...se/A100219.html

rudy

Thanks rudy, I will look into this one.


Cheers for the reply

Jon