I agree also. If I did that here, my SQL server would blow up! :-P
Save the name of the file in SQL and the images on a server. In the code, have use the path and file name to serve the image. -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 17, 2007 8:58 AM To: SQL Subject: Re: Storing Images in SQL >>How would I go about storing images in a SQL database or is it recommended? NOT recommended. Database are made for storing information so that it can be search, sorted and fully or partially retrieved. There is nothing to search, sort or partially retrieve in images, they are just files. The sytem directories are made especially to store and retrieve files, so it is better to use it for that purpose. Use the database for what it is made for: store information about images, size, type, title, description, file name, etc. and store the file in some image directory. Storing files in the database will just put some overhead on the database engine and bring no advantage. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2687 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
