Thanks for your time!
I'm using:
WDS 3.0
UNCFATPHInstaller.msi
NetWare 6.0 SP5, volume in NSS pool, running NSS 3.05, no compression, level 2 oplocks and client file caching both off.
I'm trying to search by file name. Can you help
Example: The indexed folder contains a file named: 120007AL.DWG
How do I search for this file by name I've tried:
file:120007AL.DWG (result: not found)
filename:120007AL.DWG (result: not found)
120007AL.DWG (result: found)
file:120007AL (result: not found)
filename:120007AL (result: not found)
120007AL (result: found)
Code:
Function query_flnm(ByVal str_flnm As String) As String
Dim mSearchClass As New Query.SearchDesktopClass
Dim resultSet As Query._Recordset
Dim str_qry As Stringstr_qry = "file:" & str_flnm
resultSet = mSearchClass.ExecuteQuery(str_qry, "System.ItemFolderPathDisplay", "", Nothing)
Try
query_flnm = resultSet(0).Value
Catch
query_flnm = ""
End TrymSearchClass = Nothing
resultSet = Nothing
End Function
Search by File Name
RedKMan
try this:
resultSet = mSearchClass.ExecuteSQLQuery("SELECT System.FileName FROM systemindex..scope() WHERE System.FileName='12007AL.DWG' ORDER BY System.FileName")
Dean Curtin