Anyone want to write a FAQ on this - it seems to come up every few weeks
(you could try looking at the archives...)
-----Original Message-----
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: 10 September 2001 13:56
To: CF-Talk
Subject: RE: Question about SQL and the IMAGE datatype
I've been tempted to do this and have stopped because I've been told it's
not a good practice. I suppose it's inefficient to do all that extra DB
work when you can just store a path to the image. I'd like to hear any
opinions on just why this is a bad practice. Any thoughts?
Thanks,
EC
-----Original Message-----
From: Mark Stewart [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 8:49 AM
To: CF-Talk
Subject: RE: Question about SQL and the IMAGE datatype
Kelly - I've used the image datatype before (sql server) and I've since
reverted back to just storing images on disk and entering the path in
the db. We stored the images as blobs - there are two custom tags out
there cfx_putimage and cfx_getimage that do this for you. Someone above
me stated that blobs were not that great, so we reverted back. Honestly,
I can't say why we did that because it seemed to work just fine.
Mark
-----Original Message-----
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 07, 2001 12:29 PM
To: CF-Talk
Subject: Question about SQL and the IMAGE datatype
Has anyone every used the IMAGE datatype? Is there any advantage to
this, as opposed to just putting an image name in a text field and
then linking to it in the output via an img src tag? I just haven't
used it so not sure why it would be a good thing. Also how exactly
do you get the image in the field?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
