Images from database - format?

[John]

I'm storing JPG images in a sql server table (column type 'image'), and
extracting them using a GetImage.aspx?id=99 type command.

But when I view the page in my browser and right-click on the image, it only
allows me to save it as a BMP!! Is there any way to tell what's comming down
the wire, BMP or JPG format?

I obviously don't want the extra overhead of transmitting raw bmps.

Thanks,

John

 

[Lucas Tam]

Is there any way to tell what's comming down
the wire, BMP or JPG format?

You'll need to read the byte header of the BLOB, or you can add a column in
the table flagging the image type.

 

[Steve C. Orr [MVP, MCSD]]

You should also save the ContentType of the file in the database so you can
transmit that information along with the image.
Here's an example:
http://steve.orr.net/content/asp200307so_f.asp