Hello, i have a little problem with the WHERE CONTAINS statement.
I'm an MS Access ans SQL neophyt, i begin working with them only 1
month ago. I bought the book "Professional Active Server Pages 3.0",
in chapter 12 there is a short asp prog that should make a search in a
database. But when i adapted it to my work it didn't worked.
The SQL statement is the following:
strSearch = "SELECT DocTitle, Path, FileName, Characterization,
Size" & _
" FROM SCOPE()" & _
" WHERE CONTAINS ('" & Request.Form("txtSearchFor") & "')"
Running this program IIS gives an error : Undefined function
'CONTAINS' in expression.
I must make a match words search and i don't know any other tecniques
to do that.
Any suggestions ? What is wrong in this code ?
Thanks in advance for any help.