January 22nd, 2003, 02:24 PM
|
|
Contributing User
|
|
Join Date: Aug 2002
Posts: 221
Time spent in forums: 1 Day 13 h 43 m 33 sec
Reputation Power: 6
|
|
Problem getting .pdf Titles with CreateRecordSet()
Hi all,
This is what I have:
PHP Code:
set Q = Server.CreateObject("MSSearch.Query")
set util = Server.CreateObject("MSSearch.Util")
Q.Catalog = "Something"
Q.AllowEnumeration = TRUE
Q.Query = CompSearch
Q.SortBy = "filename[a]"
Q.Columns = "DocTitle, URL, filename, size"
Q.MaxRecords = 1000
wScopeQuery = "file:" & ActualRoot2 & VirtPath
util.AddScopeToQuery Q, wScopeQuery, "deep"
set RS = Q.CreateRecordSet("sequential")
if Not RS.EOF and Not RS.BOF then
wFilenmtmp = LCase(RS("filename"))
StrLen = Len(wFilenmtmp)
CharsLeft = StrLen - 4
wFilenm = Left(wFilenmtmp, CharsLeft)
wExt = Right(wFilenmtmp, 3)
if wExt = "doc" or wExt = "pdf" then
wVpathDoc = Mid(RS("URL"), Len(ActualRoot) + 5)
wDoctitle = RS("DocTitle")
wSizeDoc = FormatNumber(RS("size"), 0)
else
if wExt = "zip" then
wVpathZip = Mid(RS("URL"), Len(ActualRoot) + 5)
wSizeZip = FormatNumber(RS("size"), 0)
end if
end if
....other code
This works great if the files are either of .doc or .zip type. But fails to get the title
of a .pdf type. The filename, url and size are ok...but the Title is missing when a .pdf
file is found.
I have verified many time that the .pdf file do have a title on them, both by checking their properties
and by mouseover, shows type, title and size.
The files are managed by VSS.
Any ideas why the .pdf Titles are not being grabbed?
Thanks.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
