View Single Post
  #1 (permalink)  
Old December 19th, 2003, 02:45 PM
kend kend is offline
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default BLOB field file types

My company's SQL Server 2000 database has a field which may store BMP or text files.

I want to use an ASP file to retrieve these files, but I don't know how (or if it's possible) to "sniff" the content type of the file in the BLOB, so I can choose the appropriate contenttype setting when the file is retrieved.

Can anyone help? Is this possible, and if so, sample code would be much appreciated.

Thanks in advance,
Ken