Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How do I querey a Content source with ADO?

  Asked By: Ezequiel    Date: Nov 30    Category: Sharepoint    Views: 586

I have written an ASP page that uses an ADO DAV query to return
documents from the WSS. and everything is cool so far!

"select ""DAV:href"", " &_
" ""urn:schemas-microsoft-com:publishing:ShortcutTarget"", " &_
" ""urn:schemas-microsoft-com:office:office#Author"", " &_
" ""DAV:displayname"", " &_
" ""urn:schemas-microsoft-com:office:office#Title"", " &_
" ""DAV:getcontentlength"", " & _
" ""DAV:getlastmodified"", " & _
" ""DAV:contentclass"", " & _
" ""urn:schemas-microsoft-com:office:office#Author"", " &_
" ""urn:schemas.microsoft.com:fulltextqueryinfo:description"", " & _
" ""urn:schemas-microsoft-com:publishing:isdoclibrarycontent"", " & _
" ""DAV:iscollection"", " & _
" ""urn:schemas-microsoft-com:publishing:DiscussionTarget"", " & _
" ""urn:schemas-microsoft-com:publishing:BestBetKeywords"", " & _
" ""urn:schemas.microsoft.com:fulltextqueryinfo:rank"" " & _
" FROM SCOPE('DEEP TRAVERSAL OF """ & request.querystring("Cat")
& """') " &_
" where ""DAV:isfolder"" = false "
if request.querystring("Find") <> "" and len(request.querystring
("Find")) > 1 then
SQLString = SQLString & " and FREETEXT('" & request.querystring
("Find") & "' ) "
end if
SQLString = SQLString & " ORDER
BY ""urn:schemas.microsoft.com:fulltextqueryinfo:rank"" DESC "

However I need to be able to return documents from other content
sources, I can see the content source root using plex but there
appears to be no documents to query (Seems fair as the documents
aren't in the WSS).

Setting the parameter CAT to a content source root does not work.

How do I query the Content source index ?

Share: 

 

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

 
Didn't find what you were looking for? Find more on How do I querey a Content source with ADO? Or get search suggestion and latest updates.




Tagged: