to get the ball rolling >> What do you guys do?
renaming uploaded file names: to comabat multiple files with the same filename (for a homespun CMS) I rename* the files with the ID of the db entry (usually a UUID) and parsing the content to replace the filename with it's new name. I also hang onto the old filename for alt tags and display for editing details and also have a field (with an index) for the filetype/extention (helps with mime types, etc). also helps with versioning with a bit more work... id | orig_filename | extention | added_on | added_by | updated_on | updated_by | ...etc <a href="#qry.id#.#qry.extention#">View file #qry.orig_filename#</a> etc... my 2c worth barry.b *past tense - haven't worked on it for over two years - rather use Farcry now-a-days... > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Chad > Renando > Sent: Monday, 20 June 2005 1:01 PM > To: CFAussie Mailing List > Subject: [cfaussie] cfdirectory or accessing the DB (was Getting the > date created of a file using CF) > > > Which brings up another Q... > > When dealing with files, I typically manage everything through the DB. > When it goes in, I create a record in the DB. Any updates or > deletions of the file are managed by updating the record in the DB. > > My thought behind this was to better manage the files and the > information stored against them. What do you guys do? > > Chad > who would be thoroughly enjoying a ham and cheese if he hadn't put on > too much hot mustard > > On 6/17/05, Mark Stanton <[EMAIL PROTECTED]> wrote: > > Any ideas guys - this has got me completely stumped. Only interested > > in windows platform for this. > > -- > > Mark Stanton > > Gruden Pty Ltd > > http://www.gruden.com > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
