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]

"John" <js************@ecclesdeletethiscollege.ac.uk> wrote in news:eRFyo#
2h*******@TK2MSFTNGP11.phx.gbl:

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.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[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

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"John" <js************@ecclesdeletethiscollege.ac.uk> wrote in message
news:eR***************@TK2MSFTNGP11.phx.gbl...

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