Hi,
I am trying to search for a phrase "National Conference" in one of the
documents which is indexed for search using the indexing service. My search
page is an ASP.NET page. Below is the SQL query I am using to get the
results, but I am getting this error "Incorrect syntax near 'Conference'.
Expected '&', '\'', ')', '|', '~', OR, AND, NEAR. SQLSTATE=42000". Please
help me resolve this problem.
Dim strQuery As String
strQuery = "Select doctitle, vpath, path, rank, characterization from
SCOPE() WHERE CONTAINS('" + TextBox1.Text + "') "
Thanks,
Vasantha