in this case I'd suggest implementing J2EE container security. You can
secure any resource this way.
DK
On 1/18/07, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
Yes and I've seen a situation where images needed security; it is due to
the site's purpose in life. *cough* Tommy *cough*
mcg
*John Mason <[EMAIL PROTECTED]>*
Sent by: [EMAIL PROTECTED]
01/18/2007 02:49 PM Please respond to
[email protected]
To
[email protected] cc
Subject
RE: [ACFUG Discuss] Image from DB
I agree that with strict image security it is an option. Give an image
only to particular people, etc. But data management? I don't think so, but
let's just my opinion. Image security is probably the only practical example
I can think of for doing this, but there again Derrick isn't going for that.
As far as having html text and the image binary on the same 'page'...I've
never send that before.
John
[EMAIL PROTECTED] <[EMAIL PROTECTED]>
------------------------------
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Josh Adams
*
Sent:* Thursday, January 18, 2007 2:42 PM*
To:* [EMAIL PROTECTED]
Subject:* RE: [ACFUG Discuss] Image from DB
Not true--there can be a benefits: data management & security. Derrick
started this whole discussion on the BlueDragon Interest list. I guess he
brought it here because no one could tell him a technique for doing what he
wanted on that list. But over there just as here, people asked the "why
would you do that?" question about storing images in the DB. An good rule
of thumb was put forth: if it's "page furniture," keep it in the file
system; if it's data, keep it in the DB. If it's data, use your data
management tool (a.k.a. your database) to manage it--why reinvent the
wheel? On the security side of things, note that by using <img
src=".../myheaderimage.cfm">, you can implement all the same security you
would for any other resource your app serves up.
Josh
------------------------------
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *John Mason
*
Sent:* Thursday, January 18, 2007 10:27 AM*
To:* [EMAIL PROTECTED]
Subject:* RE: [ACFUG Discuss] Image from DB
Honestly, there's not really a benefit per se. There might be a rare case
now and then for doing this, but really you should probably just use the
filesystem for what it's design for, storing files.
John
------------------------------
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Fennell,
Mark P.*
Sent:* Thursday, January 18, 2007 10:22 AM*
To:* [EMAIL PROTECTED]
Subject:* RE: [ACFUG Discuss] Image from DB
I'm just curious. What are the benefits of storing the image in the db
rather than storing the file on the filesystem and the path in the db? I
mean, for a web page, all you need is the <img> and the path. I can
understand how it might be useful in some VB or C or Java app where the
client doesn't display images with such ease, but for a web app...? Thanks.
mf
-----Original Message-----*
From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of *John Mason*
Sent:* Thursday, January 18, 2007 10:16 AM*
To:* [EMAIL PROTECTED]
Subject:* RE: [ACFUG Discuss] Image from DB
I believe there would still be three http requests here. The images would
still be called up in the html like <img src=""> right? Sorry but in http
that would still create seperate http requests.
John
[EMAIL PROTECTED] <[EMAIL PROTECTED]>
------------------------------
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Derrick
Peavy*
Sent:* Thursday, January 18, 2007 9:35 AM*
To:* [EMAIL PROTECTED]
Subject:* [ACFUG Discuss] Image from DB
Probably an easy problem for someone...
I want to put two small images in my database and then output them in my
app, so that they do not constitute additional http requests. Consider it an
experiment - I know that it may seem a bit silly. The goal is for the entire
page to be delivered to the browser in one http request, instead of 3 (two
images and one cf page) without doing any Apache tinkering. I have looked
around the net for answers and cannot seem to make this work.
Database field is "imageFile" of type BLOB in MySQL 4.1.13. What is the
proper way to insert the image?
Example: INSERT into Images (imageFile) values ('#base64(image)#')
-Or-
Example: INSERT into Images (imageFile) values ('#image#')
And then of course, how do you retrieve it? Example: SELECT imageFile FROM
Images WHERE imageID=1
<cfoutput>
#toString(imageFile)#
</cfoutput>
-OR-
<cfoutput>
#toBinary(imageFile)#
</cfoutput>
As I say, I've not been able to make this work. If I use toString(), I
simply get the raw data. If I use toBinary(), I get an error that the data
cannot be converted to a string. Also, using CFCONTENT is fine to output the
image, but then any code after that is ignored. So, short of saving the
entire page and then outputting, it, I don't see a way to use CFCONTENT.
_____________
*Derrick Peavy*
*Sales and Web Services *
*Universal Advertising*
*Phone: 404-786-5036*
*Fax: 404-370-0470 *
*http://www.universaladvertising.com*<http://www.universaladvertising.com/>
*http://www.collegeadvertising.com* <http://www.collegeadvertising.com/>
*http://www.collegeclassifieds.com* <http://www.collegeclassifieds.com/>
*___________________________________*
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @ *
**http://www.acfug.org?fa=login.edituserform*<http://www.acfug.org?fa=login.edituserform/>
For more info, see
*http://www.acfug.org/mailinglists*<http://www.acfug.org/mailinglists>
Archive @
*http://www.mail-archive.com/discussion%40acfug.org/*<http://www.mail-archive.com/discussion%40acfug.org/>
List hosted by *FusionLink* <http://www.fusionlink.com/>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @ *
**http://www.acfug.org?fa=login.edituserform*<http://www.acfug.org?fa=login.edituserform/>
For more info, see
*http://www.acfug.org/mailinglists*<http://www.acfug.org/mailinglists>
Archive @
*http://www.mail-archive.com/discussion%40acfug.org/*<http://www.mail-archive.com/discussion%40acfug.org/>
List hosted by *FusionLink* <http://www.fusionlink.com/>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @ *
**http://www.acfug.org?fa=login.edituserform*<http://www.acfug.org?fa=login.edituserform/>
For more info, see
*http://www.acfug.org/mailinglists*<http://www.acfug.org/mailinglists>
Archive @
*http://www.mail-archive.com/discussion%40acfug.org/*<http://www.mail-archive.com/discussion%40acfug.org/>
List hosted by *FusionLink* <http://www.fusionlink.com/>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @ *
**http://www.acfug.org?fa=login.edituserform*<http://www.acfug.org?fa=login.edituserform/>
For more info, see
*http://www.acfug.org/mailinglists*<http://www.acfug.org/mailinglists>
Archive @
*http://www.mail-archive.com/discussion%40acfug.org/*<http://www.mail-archive.com/discussion%40acfug.org/>
List hosted by *FusionLink* <http://www.fusionlink.com/>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @ *
**http://www.acfug.org?fa=login.edituserform*<http://www.acfug.org?fa=login.edituserform/>
For more info, see
*http://www.acfug.org/mailinglists*<http://www.acfug.org/mailinglists>
Archive @
*http://www.mail-archive.com/discussion%40acfug.org/*<http://www.mail-archive.com/discussion%40acfug.org/>
List hosted by *FusionLink* <http://www.fusionlink.com/>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
