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. :) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
