Dates and range searches
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41274
interpreted = N
texte = Hi group, I'm dealing with archiving news images and I would like to be ableto deal with the creation dates of digital photos that are embedded in thethe data fork of the file itself.I can export all the data in a tab delimited file after it has beenannotated in iView Media Pro. The problem being is that the date/timeformat is embedded like so: 12/16/02 7:59:12 PM. Is there any way to dealwith this or will I have to have this entered manually when the photographerannotates the files?Also, when I export the data and I want to have a trigger merge it, (a tempdb) each day to the archive db, can I have it add a [datearchived] fieldwith today's [date] to each record so I can set up search by date rangequieries?Any thoughts would be appreciated.TIAKen M-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
|
- Dates and range searches (Ken MacMurchy 2002)
|
Hi group, I'm dealing with archiving news images and I would like to be ableto deal with the creation dates of digital photos that are embedded in thethe data fork of the file itself.I can export all the data in a tab delimited file after it has beenannotated in iView Media Pro. The problem being is that the date/timeformat is embedded like so: 12/16/02 7:59:12 PM. Is there any way to dealwith this or will I have to have this entered manually when the photographerannotates the files?Also, when I export the data and I want to have a trigger merge it, (a tempdb) each day to the archive db, can I have it add a [datearchived] fieldwith today's [date] to each record so I can set up search by date rangequieries?Any thoughts would be appreciated.TIAKen M-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Ken MacMurchy
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
find with exceptions (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Unix DB Permission Error (2002)
Mac Vs WindowsNT (1997)
Loss in Form (1998)
[WebDNA] [OT] hello (2012)
Re:Signal Raised (1997)
'RequiredField' Question (1998)
[OT] Applescript (2003)
[OT] (waaaay OT) further off topic than before (2004)
send mail problem? (1997)
Limitations on fields? Server is crashing (1997)
5.0 Pricing (2003)
E-mailer error codes (1997)
MacOS X Server 1.2 Netnameserver conflict (2001)
using showpage and showcart commands (1996)
webcat method for waiting specific amount of time? (2000)
.FBCLockFolder messin' things up.... (2001)
WebCat2 - [format thousands] (1997)
View order not right (1997)