|
I have a Verity Collection that indexes a few thousand files
(MS Word, PDF, etc.) on a FTP site...external to our CF server. Besides
outputting the url, key, title, score, and summary from Verity…I
also wished to display to file name, file size, and most
importantly…date file updated or at least when pasted to the FTP
site. So I Googled around and found the following cfscript that
creates a file system object:
<cfscript>
strFile = "#URL#";
fso = CreateObject("COM", "Scripting.FileSystemObject");
f = fso.GetFile(strFile);
</cfscript> With this script, I can display “f.name”,
“f.path”, “f.size”, and “f.DateCreated” in
conjunction with the regular Verity variables outputted from a files-based
Verity Index Collection. I actually outputted from a
Query-of-a-Query so the users could select a sort order…though limited to the regular Verity variables.
OK, here are my problems: 1. The users
wish to be able to sort the
results of a Verity search by file size and
most importantly by dateCreated…which I output using the above
cfscript. 2. If a file is
deleted directly from the ftp site…and a Verity search pulls that file,
an error message is generated pointing to the above cfscript (instead of just a
dead hyperlink). Of course, the error disappears after re-indexing. I thought about doing a cfdirectory query above Verity then
somehow joining it on the query-of-a-query. However, the FTP site files
are at multiple folder levels and I think I heard that cfdirectory is not
recursive on CF5? Your feedback / suggestions will be very much appreciated! Note: Our production server is still running
CF5…though we will be migrating to CFMX 7 hopefully within the next 6 to
12 months. Regards, Gordon M. Cantor (803) 758-4621 |
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
