> 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.
> TIA!!
As far as I know it's the only approach if you don't have a way to
control access to the file if you can't use directory structure to
control access. Afaik you would typically perform an upload and then
use cffile action="" to get the binary data. The variable
returned from cffile can then be inserted into the database... I want
to say using cfqueryparam, although off the top of my head I don't
know what value you would provide for the cfsqltype attribute. I
suppose you could try omitting the attribute since it's not required,
although I never do myself. Oddly enough, I've never worked on an
application where I needed to store binary files in the database so I
can't give you any first-hand information, though I believe once you
have the data in your database you can use cfcontent to deliver it and
cfheader to give it an appropriate file name in the client browser. I
believe there's a way to avoid writing the binary string to disk
before the cfcontent download (which you'd do with deletefile="true"
in a worst-case scenario), although again I haven't ever needed it, so
I don't have any first-hand experience.
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
http://www.sys-con.com/story/?storyid=45569&DE=1
http://www.fusiontap.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
