How to Display A Stored TIF Blob field in SQL Server

[mofufus23]

Does anybody know how to display a TIF blob field in SQL Server? :confused;

[PaulH]

don't know that you can. don't you need some kind of plugin to display non-gif/jpeg/png images?

[unleashed]

I'm not sure if this will work for TIF's, but it does work for JPEG's...

This is how I do it... (In your CF Administrator, under your datasource, you
need to make sure you select "Enable binary large object retrieval (BLOB)" and
adjust your "Blob Buffer(bytes)" accordingly. By default the buffer size is
64kb and images will be truncated if larger than 64kb.)

Your page containing information and image that you want to display.
*******************************************
<cfquery>
SELECT * FROM EMPLOYEES
</cfquery>

<img src="getPhoto.cfm?EmployeeID=#EmployeeID#" border="0" width="144"
height="180">
<!--- This calls your getPhoto.cfm page and passes in your EmployeeID --->
<br>#EmployeeName#
*******************************************

In your getPhoto.cfm page...

<!--- Need to have these two lines, you only want the image to be streamed
back to your display page and not any other text. --->
<cfsetting enablecfoutputonly="Yes">
<cfsetting showdebugoutput="No">

<cfquery name="getBlob">
SELECT TOP 1 EmployeePhotoBlob, EmployeeName FROM Employees WHERE EmployeeID =
#EmployeeID#
</cfquery>

<cfheader name="content-disposition"
value="Inline;filename=#EmployeeName#.jpg">
<cfcontent type="image/tiff; charset=iso-8859-1"> <!--- This tells the page to
export in TIFF format. --->
<cfoutput>#tostring(tobinary(getBlob.EmployeePhoto Blob))#</cfoutput>

************************************
Hope this helps...

James
Sacramento, CA