I agree. Try to avoid storing big amounts of data directly in the db, especially when it doesn't do any good being there.
Travis ---- Original Message ---- From: Mary Jackson <[EMAIL PROTECTED]> Sent: 2001-12-06 15:24:37.0 To: SQL <[EMAIL PROTECTED]> Subject: Re: HELP with inserting a file into SQL What SQL are you using? SQL Server 7 and 2000 have an Image data type. But why would you want to. Your database will be huge and slow. You can store the HTML for the image in a column <img src="../../graphics/another.gif" width="85" height="19" border="0" alt=""> and keep the image on your server. If you really need to I found some articles (although not all CF, other languages but they may help) http://www.faqts.com/knowledge_base/view.phtml/aid/6726/fid/51 http://lists.zope.org/pipermail/zope/1999-July/090267.html http://www.umachandar.com/technical/SQL6x70Scripts/main.htm I just did a quick search, hope there is something you can use. At 04:59 PM 12/6/01 -0500, you wrote: >As most of you know SQL has a datatype of Binary that can hold an actual >binary file and has a datatype of image that can hold an image file. I >sent this question yesterday but go no response figured I would try once >more. Obviously I know how to insert DATA into SQL. But w/ in that >insert statement does anyone know how to insert a binary file or an image >file into a SQL database? Any help would be most appreciated. :) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
