Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Lose Documents in Sharepoint Search Query

  Asked By: Jackson    Date: Aug 19    Category: Sharepoint    Views: 1140

We implement Sharepoint 2001 with a Webpart that Search Documents
Recursive. I do this with the Following Search Query

SELECT "urn:schemas-microsoft-com:office:office#Author",
"urn:schemas-microsoft-com:office:office#Title", "DAV:href",
"DAV:getlastmodified","DAV:displayname" FROM SCOPE('DEEP TRAVERSAL OF
"http://myserver/MyWorkspace/Info/News/Professionell/"') where
"DAV:isfolder" = false order by "DAV:getlastmodified" desc,
"urn:schemas-microsoft-com:office:office#Title" desc

Search Querys like this I and open over the function:


'Functionname: OpenRS
'Input: sSQL (SQL String)
'Output: OpenRS = Bit, rsTable = Recordset
Function OpenRS(sSQL, rsTable)
Dim rsRecordset
On Error Resume Next
Set rsRecordSet = Server.CreateObject
("ADODB.RecordSet")
OpenConnection
rsRecordset.Open sSQL, connDBConnection, adOpenDynamic
,adLockOptimistic
If Err.Number <> 0 Then
If IfDebug then
Response.Write "<br>Error: SQL
String: '" & sSQL & "'<br>"
Response.Write "" & err.number &
"
<br>"
Response.Write err.description &
"<br><br>"
End If
OpenRS = False
Else
Set rsTable = rsRecordSet
If rsRecordSet.EOF Then
If IfDebug then
Response.Write "<br>Es sind
keine Daten vorhanden!<br><br>"
End If
OpenRS = False
Else
OpenRS = True
End If
End If
Set rsRecordset = Nothing
End Function


I Open the Connection sipmle over msdaipp.dso.
In many Thimes I have Documents where don't are displayed in Webpart.

Has anywhere an idea wat can be the Problem? I think the SPS lose
documents in his index.

Share: 

 

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

 
Didn't find what you were looking for? Find more on Lose Documents in Sharepoint Search Query Or get search suggestion and latest updates.




Tagged: