Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SPS V2 Search syntax

  Asked By: Rohit    Date: Apr 05    Category: Sharepoint    Views: 669

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.

Share: 

 

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.




Tagged: