help mssql full-text search

[atdawgie]

I execute this query on Mssql 7 server:

"SELECT * FROM JOBS WHERE CONTAINS(description, 'wildlife')";

and get the result below. The syntax looks fine I think?

Warning: MS SQL message: Search on full-text catalog 'jobs_full_textindex' for database ID 12, table ID 949578421 with search condition 'wildlife' failed with unknown result (55df954). (severity 17) in c:\wwwroot\jobs\keywordsearch.php on line 17

Thanks,
Aaron

[PHPdev]

What do you have the fields defined as? There are certain field definitions that can not be searched, if I remember correctly...

PHPdev