473,322 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Using CONTAINS PREDICATE of Indexing service in ASP.NET page

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
Nov 22 '05 #1
0 1389

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: C | last post by:
Hi, I currently use MS Indexing Service to search my htm and aspx pages. I recently downloaded the IFilter tool from Adobe. When I now do a search it still does not pick up any text in my...
5
by: HumanJHawkins | last post by:
Hi, I have a table of text. I need to search for whole words within this text... For example, I need to be able to search for records that contain 'dog' but not return 'hotdog' or 'dogma' for...
0
by: Vasantha peddireddy | last post by:
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...
0
by: DLacey | last post by:
I have a .NET C# application that uses the indexing service. It adds folders to the catalog to be indexed, removes them, etc. Currently the application requires the user be an admin user in order...
3
by: jliusolar | last post by:
Hi I am trying to figure out why an application get this error when I am trying to open the application's asmx file from localhost. I don't have indexing service running(it set as manual and not...
0
by: Z D | last post by:
Hello, I've installed and setup MS indexing service on my webserver (IIS v6). It seems to work fine as basic searches are indeed working. The problem, however, is that indexing service does...
0
by: Vito DeCarlo | last post by:
Does anyone have any idea as to a workaround for using dynamic TITLEs with Indexing Service? For example, due to the fact that we're using Master Pages, we're dyanamically creating the TITLE...
2
by: sianan | last post by:
I am having a problem doing the following in generics. I have two list of a custom item type. I need to iterate through the first list and match each item against another list to see if there is...
10
by: William Krick | last post by:
I am writing an XSL transform that converts XML data about vehicles into XML data that will fill printed forms. The default form can handle up to 5 vehicles which I handle using subscripts... ...
0
by: ruth1 | last post by:
I am using CIODMLib for handaling my Indexing service catalogs from a certain day all functions of AdminIndexServerClass are raising an ERROR "Cannot find file specified" Even though that the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.