Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

SPS V2 Search syntax

  Asked By: Rohit Chavan         Date: Apr 05, 2010      Category: Sharepoint      Views: 209
 

I have a question that I HOPE someone out there can help me with. I am
trying to link into the query web service that ships with V2, but I come up
against a wall and hope someone out there can help me.

I have gotten the keywords query service to work fine, but I can't for the
life of me get the query to work to use the MS SQL syntax. Here is the query
that gets passed to the service:

urn:Microsoft.Search.Response.Document.Document
SELECT "DAV:href", "DAV:displayname", "urn:schemas.microsoft.com:fulltextquery
info:description", "urn:schemas.microsoft.com:fulltextqueryinfo:rank", "urn:sc
hemas.microsoft.com:fulltextqueryinfo:displaytitle" FROM S_67B65B1BE6 WHERE
CONTAINS(' "project" ')

This is the exact syntax I get when I do a Response.Write of the query string
that is passed. Here is the error message I get back from the service:

<?xml version="1.0" encoding="utf-16"?> <ResponsePacket
xmlns="urn:Microsoft.Search.Response"> <Response domain="ExecutiveBoard">
<Copyright>Microsoft (c) Office SharePoint (tm) Portal Server
2003</Copyright> <Status>ERROR_SERVER</Status> <DebugErrorMessage>Internal
server error</DebugErrorMessage> </Response> </ResponsePacket>

ANY Help is appreciated. I just don't understand why I can get the keywords
to work but not the SQL syntax.


Do you know someone who can help? Share a link to this thread on twitter, or facebook.

Tagged:        

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on SPS V2 Search syntax Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].