Show PIctures or MP3 files Ole Object

[djaccess]

smokie i would love to use that cart from red eye to sell more or less the same thing. But mine is going to have a radio station built into it. Secoundly with regards to this shopping cart, if im using access to save my product info and i want to display and sound file or image from an ole object in access how would i do this on the asp page cause have tried standaerd results field and come up with a load of **** like ---< %$09% >--- which means sod all to me. I just to make some money quick befoe i go bank rupt as there is no web design work any more and im quilifed sql dba and can't find any work there.

[Smokie]

you got a BLOB in your database then... are they all sound files or all images? You need to know what type of file you are outputting before you output it... for an image...

Response.ContentType = "image/gif"

Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "DSN=myDSN;UID=sa;PWD=;DATABASE=pubs"
Set rs = cn.Execute("SELECT pic_object FROM picture_tbl WHERE pic_id='" & pic_id & "'")

Response.BinaryWrite rs("pic_object")
Response.End

Hope that helps