Keyword search ? 1

[qajussi]

Hi!

I am trying to find a way to do a keyword search using vbscript or ado on Access table.

From the webpage, the user will enter keyword and I would like to search it against the access database table.

I only need to search on one column of the table which contains company namses.

TblCompany
CompanyID
CompanyName
etc.

The company name is a string of text which contains multiple words.

The user will enter a keyword(one word) and I would like to find companyID with company name having that word.

I don't know how to tackle this.
Any help will be greately appreciated.
Thanks.

IS there a keyword search capablility tool out there I can use?

 

[PHV]

Take a look at the Find method or the Filter property of the ADODB.Recordset object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[qajussi]

Thank millions PHV AGAIN!

You are awesome!!
One of my clients came back asking for the keyword searching capability.

I thought I would have to extract and parse the string into a single word and loop through to compare.

Gee, it can be done with one filter statement.
Thanks you made my day.