Re: [ cf-dev ] CF anf BLoBs

[Matt Horn]

Hi Steve this is the way I usually do it however  its not my code or DB   I am dealing with someoneelses great idea :P  and its MSSQL   Thanks     ----- Original Message ----- From: Steve & Karen Kahn To: [EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 3:30 PM Subject: RE: [ cf-dev ] CF anf BLoBs Matt First of all what type of database are you using? If its Microsoft SQL than make the field that is to store the image a “varchar”. Now when you input the data, do not put the file in. Instead put the server path To the file. “web/images/picture_blob.jpg”. Now when you want to show it on a page. Use a standard <CFQuery name=bubba> select * from myfield </cfquery> Then Use a <cfoutput query=blob>#bubba#</cfoutput>   Hope that helps. Steve   -----Original Message----- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 6:56 AM To: [EMAIL PROTECTED] Subject: [ cf-dev ] CF anf BLoBs   Hi  I am having to deal with images stored as BLoBs in a DB    how in gods name do I query the DB for the blob and display the image?   I tried query it out .. use cfcontent to display with correct mime type .. no good    any ideas? thanks   |\--------------------/| Matt Horn Web Applications Developer Ph:+2782 424 3751 W: http://www.matt-horn.org E:[EMAIL PROTECTED] |\--------------------/|