Hi guys,

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

Here's the scenario .... I'm using 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 is called sSchool which is simply a drop down on the search page and the keyword one is text box. The variable code the keyword is ...

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

My SQL is 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!!!

Thanks in advance

Jon

Can you throw up what launguage you're using and details of your platform please.

Thanks

_________________________
WinXP : IIS 5.1 : StudioMX : ASP : VBScript
www.dynamic.ie

Hi there, I'm using ASP, but have managed to sort it now, thanx for the reply anyways though.

Cheers

Jon

I am having the same problem... can you post how you resolved this issue please?

Vegas