MS Access SQL Word Frequency

[kinneh]

Hi

I'm trying to build a search system using MS ACCESS (and classic asp) which returns the most relevant results at the top.

I have a memo field that stores a large description. Is it possible to calculate how many times a string appears in this description?

E.g. If the word 'advisor' appears in the description 10 times, I need it to return the number 10.

Thanks for your help.

 

[kinneh]

Thanks a lot.

 

[kinneh]

This works fine when executing the query in MS Access.

However, when i try and execute the the stored query using my classic ASP script, it errors.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Undefined function 'Replace' in expression.

Basically, JET doesn't support the Replace function.

Do you know if its possible to get this working at all?

My code to execute the query is below:

query = "EXECUTE q_storedQuery '" & parameterVariable & "'"
set RS = Server.CreateObject ("ADODB.Recordset")
RS.Open query, DataConnVac, adOpenKeyset, adLockOptimistic