But you're right - the requirements of the job are the critical factor here.
The application needs to allow different users to do different things so security needs to be at application level to control and manage that.
The challenge for me then is that I need to "link" the student's dossier to the record so that it can be viewed on line buy authorised users or be selected and emailed to an authorised user. Once submitted the dossier is "written in tablets of stone" - it can't be updated so there is no need to be able to update these docs once loaded.
Storing it as a file means that it can be located by persons other than authorised users and this is not desirable as they contain personal and sensitive info.
Both our Intranet, which is Livelink based, and our new M$ CMS based web site (please don't ask :-( , store everything in binary format. Livelink has thousands of docs and our CMS has about 1,500 PDF's plus about 250 media streams. In both cases these are rendered from SQL Server on the fly, although M$ CMS does heavily cache common file requests. So it seems that SQL Server might be up to the task notwithstanding the discussions in this thread.
While storing the student dossier as a file is quite easily coded I do need to lock them down from prying eyes - any suggestions greatly appreciated.
++++++++++
Kevin Parker
Web Services Manager
WorkCover Corporation
p: 08 8233 2548
m: 0418 806 166
e: [EMAIL PROTECTED]
w: www.workcover.com
++++++++++
-----Original Message-----
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 21 September 2004 11:41 PM
To: CF-Talk
Subject: RE: BLOB
Exactly, opinions don't matter when it can't change the requirements of
a project.
I have seen snippets of code, but never a complete, working example.
I sure would appreciate it, as would many others.
________________________________
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 8:57 AM
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
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
