I've considered doing that (with SQL Server).
Before you beign, I've been told over and over again is that it's a bad
practice to store images in databases. Instead, have a column that points
to the path of the file.
In you do that, you'll have to cffile (write) the data the pull from the
database into a jpeg file. Then use CFcontent to display (and delete).
This method is pretty slow when you do several images at once.
Just letting you know just in case.
As for mySQL, I dunno. :/
EC
-----Original Message-----
From: Paris Lundis [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 4:28 PM
To: CF-Talk
Subject: MySQL and binary data
ok was wondering if anyone using MySQL with ColdFusion, if they were
utilizing the BLOB types to store data in the database?
Specifically, I am wondering how easy it is or isn't to write things like
JPEGs in there and get them back out and into the Cold Fusion pages...
anyone have any sample code, recommendations, pointers, etc?
-paris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
