How to get binary file from SQL field?

[les]

I want to display binary data from SQL server 2000 in an asp page. The
data comes from a Windows Sharepoint Services document library.

The raw data is in a field called "content" and there is another field
"extension" that gives the file extension of the file.

Presumably I have to get the asp to recognise the file type and deal
with it accordingly...

How do i do this?
Thanks
Leslie

[Aaron Bertrand [MVP]]

There are links to three KB articles at the bottom of
[url]http://www.aspfaq.com/2149[/url] which should yield some helpful code snippets.






<les> wrote in message news:mk6frv0uojdlba8ch8tsksajqkh8j69doj@4ax.com...

> I want to display binary data from SQL server 2000 in an asp page. The
> data comes from a Windows Sharepoint Services document library.
>
> The raw data is in a field called "content" and there is another field
> "extension" that gives the file extension of the file.
>
> Presumably I have to get the asp to recognise the file type and deal
> with it accordingly...
>
> How do i do this?
> Thanks
> Leslie