Query is

select drawings.date_recd,drawings.date_revd,drawings.dty pe,sectors.sect_area,sectors.sect_count,drawings.n ame name from
drawings,sectors where drawings.name=sectors.name order by sect_area

following coding not opening the tif file why ?
when click the name link it give error message that

" the document connot be opened, the document format is invalid or
not supported"


Response.Write("<td>")
Response.Write("<font face=arial size=2><a href=" & server.URLEncode(rs("name")) & ">" & rs("name") & "</a></font>")
Response.Write("</td>")

TIF file available respective folder,
what is the problem ?
what code will use that open the TIF (image) file.
we are using intranet.

Regards

IE has no support to display tiff image, so you need to convert tiff to jpg and display the same.

Following are few conversion examples you could probably tweak:

http://aspalliance.com/articleViewer.aspx?aId=140

http://codebetter.com/blogs/eric.wis.../15/63236.aspx

http://msdn.microsoft.com/library/de...iffTopic .asp

Also there are plug-ins available to display but not sure they are free.
Example:
AlternaTIFF TIFF Plug-in (www.alternatiff.com/)

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.