John, check out this thread: http://www.forta.com/blog/index.cfm?mode=e&entry=1645
--- Ben -----Original Message----- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 2:10 PM To: CF-Talk Subject: Storing and retrieving images from SQL Server 2000 I've looked in the archives and can't find a good answer to this. I know I've done it in the past, I just can't remember how and my brain hurts so i figured i'd ask the list. I have no say about storing the images in the DB and that decision is already made, so I just need help putting them in there and getting them out. Right now, the DB is set up with a column of the type BLOB. I'm trying to figure out how to let a user upload a file and then read that file back off of the server and insert it into the database using <cfquery> but it's not working for me. Do I need to do any conversions using any cf functions before the insert? When I'm trying to pull it from the DB, I have a page that does the query and uses <cfcontent> to set the type to image/gif and then output the result of the query using <cfoutput>#queryname.value#</cfoutput> and i'm calling that page using <img src="/cfcontent.cfm"> but I'm not getting the result as expected. I think it all goes back to how I'm putting it in and pulling it from the DB. Any help would be greatly appreciated and I'd like to stay away from CFX tags if at all possible. We have tried a couple and have gotten patchy results. Thanks for your help while my brain is out to lunch! John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211659 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
