Hi

I am using Tom's dynamic search sql extension with a form with drop downs for all words, any words, exact phrase. It works as it should but I need to improve slightly.

The problem is when people are searching for something and they enter plural text.

ie If I search for

tin ceiling

I get some results, but if i search for

tin ceilings

I get no results, and apparently this is causing problems for my client.

Is there a work around this please (aside from entering the plural in an extra search column in the dn which would be too laborious a task)

Many Thanks

James

I have not read or know the Tom Muck search extension but when searching for words that can be longer you should use a wildcard like the %-sign.

A select * from [tablename] where city is = "New York" gives the exact cityname, but the query "... city LIKE "New"% gives e.g. New York, New Jersey, etc.

<hr><b>DMXZone support manager</b><br><a href="www.kousman.nl">Kousman web resellers</a>