 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ColdFusion / Advanced Techniques / May 2007coldfusion store image into db
I would like to know what size of image i can store into db. I am using SQL server. and after storing image into db how do I read it Depending on the DB you should be able to store it in a BLOB field, I would recommend storing the file name for the image and referencing the image via <img src="http://www.yoursite.com/images/#query.filename#"> thou' HTH According to MS Technet, SQL Server 2000 has a 2GB limit for BLOB fields. As for retrieving a BLOB from the DB, I've only done it with an Oracle DB. There, I had to write a Java utility class that used JDBC to store and retrieve the binary data from the DB. I can give you some example code if you're intersted |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.