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.