CONTAINS won't work for me

CONTAINS won't work for me

Post by ZU » Sat, 05 Feb 2000 04:00:00



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.

ZUC

 
 
 

CONTAINS won't work for me

Post by cert. Develope » Mon, 07 Feb 2000 04:00:00


It only works if the sql server table fields are set for full text searches
it does not work on access.. as access does not have text indexing..
you might want to try the 'LIKE' or 'HAVING' clauses for the fields
in the filter clause..


Quote:> 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.

> ZUC


 
 
 

1. CONTAINS won't work

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.

ZUC

2. Too many indexes at ODBC connect to VFP database from AC2000

3. Was 'DDL won't work'

4. returning the index

5. relationship won't work because field can't be indexed

6. DDEREG.EXE

7. What's wrong with me - easy filter in 2.5 won't work

8. US-CA-SENIOR IMPLEMENTATION SPECIALIST

9. CONTAINS doesn't work

10. CONTAINS don't work for me

11. ADO - SQL statement that contains REPLACE doesn't work

12. VB6 ADO - SQL statement that contains REPLACE doesn't work

13. ADO - SQL statement that contains REPLACE doesn't work