How to get binary file from SQL field?

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default How to get binary file from SQL field?

    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
    les Guest

  2. Similar Questions and Discussions

    1. Reading Binary File
      I am converting a PHP script and I need to know what the eqivelent of "fread('file', 1)" for CF. I am reading a binary file.
    2. Inserting binary field into SQL 2000 database
      Hi, I have been trying to upload a .pdf file to a SQL Server 2000 database. I used the dreamweaver MX auto generated code. However, I have the...
    3. Binary file IO
      Hi, What I would like to do is load a file's contents from a file on the server and put the contents into a record in a database. For this I...
    4. I need to display a PDF from SQL Binary Field
      I am trying to display a PDF from SQL. All I am getting is garbage that looks like this: %PDF-1.3 %âãÏÓ 37 0 obj << /Linearized 1 /O 39 /H /L...
    5. Output binary file
      the company I work for sometimes has users link to our banners, and display them on there own sites. the problem is that some of the banners have...
  3. #2

    Default Re: How to get binary file from SQL field?

    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

    Aaron Bertrand [MVP] Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139