SharePoint 2010 - How to get document ID using SPServices SQL search query?

Question

Using SPServices to make search requests, I am building the query like this:

var queryText;
queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>";
queryText += "<Query>";
queryText += "<Context>";
queryText += "<QueryText language='en-US' type='MSSQLFT'>";
queryText += "SELECT Title, Rank, Size, Description, Write, Path, Filename FROM Scope() WHERE CONTAINS ('" + text + "') AND ((\"SCOPE\" = '" + scope + "')) ORDER BY \"Rank\" DESC";
queryText += "</QueryText>";
queryText += "</Context>";
queryText += "<Range><Count>1000</Count></Range>";
queryText += "</Query>";
queryText += "</QueryPacket>";

How can I include the property which gives me the document ID?

Answer 1

Change the querytext to:

queryText += "SELECT Title, Rank, Size, Description, Write, Path, Filename, spdocid FROM Scope() WHERE CONTAINS ('" + text + "') AND ((\"SCOPE\" = '" + scope + "')) ORDER BY \"Rank\" DESC";