Storing data in BLOB's and CLOB's is not good full stop. It leads to
overgrown database systems and unnecessary storage of binary data. You have
to see it from this point of view, SQL and Databases per say are a data
manipulation language/design when you have data in a BLOB what are you doing
to do with it? It can't be modified or altered via SQL, so in essence its
pointless. If you have the file to insert into a BLOB then just store a
reference to that file object.
If you can give me a valid business case of storing data in this matter
which overrides the fact its bad practice then I am all ears.
N
_____
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: 21 September 2004 14:57
To: CF-Talk
Subject: Re: BLOB
>Storing data of this type in a database is not good practice, it should be
>avoided at all costs...
Your opinion doesn't necessarily = good practice.
-Adam
----- Original Message -----
From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]>
Date: Tue, 21 Sep 2004 14:29:23 +0100
Subject: RE: BLOB
To: CF-Talk <[EMAIL PROTECTED]>
Storing data of this type in a database is not good practice, it should be
avoided at all costs...
_____
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: 21 September 2004 13:50
To: CF-Talk
Subject: RE: BLOB
Read this thread
http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=
2&threadid=795052
I'm trying to do the same thing, with little success. I can't get the
binary data inserted into SQL, however, I can use ToBase64() and insert
it, but that's not really what I want to do.
I am able to get binary data (jpgs) from a database, but I'm not able to
insert a binary file.
I hope someone can shed some light on this for us all.
Thanks
________________________________
From: Parker, Kevin [mailto:[EMAIL PROTECTED]
Sent: Monday, September 20, 2004 11:23 PM
To: CF-Talk
Subject: BLOB
How do you add a file (e.g. PDF) to SQL Server as opposed to
creating a row that you convert to a URL that links to it.
I want to create an application that includes student dossiers
so I don't want them to be locatable or downloadable by anyone or
anything other than application users. Security is at application level
and managed by the application, not directory level.
Is this the best or recommended approach.
_____________________________________
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
