On Feb 19, 2005, at 7:49 PM, James Holmes wrote:
> Java way:
>
> 1) Call class to return just the chosen info on the single file in
> which you
> are interested.
vs
<cfexecute name="mdls" arguments="/mypath/myfile" variable="myMetadata">
gives:
kMDItemAttributeChangeDate = 2004-10-20 01:00:15 -0700
kMDItemBitsPerSample = 24
kMDItemColorSpace = "RGB "
kMDItemContentType = "public.jpeg"
kMDItemContentTypeTree = ("public.jpeg",
"public.image",
"public.data",
"public.item",
"public.content")
kMDItemDisplayName = "metadata.jpg"
kMDItemFSContentChangeDate = 2004-10-19 00:13:04 -0700
kMDItemFSCreationDate = 2004-10-19 00:13:04 -0700
kMDItemFSCreatorCode = 0
kMDItemFSFinderFlags = 0
kMDItemFSInvisible = 0
kMDItemFSLabel = 0
kMDItemFSName = "metadata.jpg"
kMDItemFSNodeCount = 0
kMDItemFSOwnerGroupID = 501
kMDItemFSOwnerUserID = 501
kMDItemFSSize = 21917
kMDItemFSTypeCode = 0
kMDItemID = 246476
kMDItemKind = "JPEG Image"
kMDItemLastUsedDate = 2004-10-19 00:13:04 -0700
kMDItemPixelHeight = 213
kMDItemPixelWidth = 624
kMDItemResolutionHeightDPI = 72
kMDItemResolutionWidthDPI = 72
kMDItemUsedDates = (2004-10-19 00:13:04 -0700)
and this is a highly tuned OS-level function (prolly written in C) vs a
Java function.
>
> Hmm, hard choice...
It *is* a hard choice... I f you have a Mac running Tiger available
Say what you will, but Mac Tiger has a built-in, automatic
metada/content SQL db as part of the core file system and OS...
Something like this was available in BeOS, and planned for Longhorn
(removed).
Apple began work on this in 1999 and has a patent, released recently.
Apple is said to have a 1-3 year lead in this technology.
Dick
>
> -----Original Message-----
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]
> Sent: Sunday, 20 February 2005 11:39
> To: CF-Talk
> Subject: Re: Getting IPTC data into a database
>
> [snip]
>
> Imagemagic way:
>
> 1) upload & save file
> 2) cfexecute to imagemagic to extract metadata
> 3) cfquery to insert into sql db
> 4) cfquery to search metadata & return matches
>
> Spotlight way
>
> 1) upload & save file -- automatically extracts metadata/content and
> inserts into an sql db
> 2) cfexecute CLI mdfind command to search metadata/content & return
> matches
>
> [snip]
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195612
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
