Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SPS V2 Search syntax

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

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:

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.



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.