Professional Web Applications Themes

how to show image retrieved from BLOB on the web page - Microsoft SQL / MS SQL Server

Hi, Does anyone know how to retrieve binary image data from BLOB column of SQL database table and show it on the web page. I know "img src=" tag can be directed to an image file(.gif, jpeg). But how to program this tag for streamed data, such as retrieved BLOB streamed data through ADO in code. Thanks George...

  1. #1

    Default how to show image retrieved from BLOB on the web page

    Hi,
    Does anyone know how to retrieve binary image data from
    BLOB column of SQL database table and show it on the web
    page. I know "img src=" tag can be directed to an image
    file(.gif, jpeg). But how to program this tag for
    streamed data, such as retrieved BLOB streamed data
    through ADO in code.
    Thanks
    George
    George lucas Guest

  2. #2

    Default Re: how to show image retrieved from BLOB on the web page

    "George lucas" <lucaspro3212aol.com> wrote in news:65e301c34320$bdbbc5c0
    $a401280aphx.gbl:
    > Hi,
    > Does anyone know how to retrieve binary image data from
    > BLOB column of SQL database table and show it on the web
    > page. I know "img src=" tag can be directed to an image
    > file(.gif, jpeg). But how to program this tag for
    > streamed data, such as retrieved BLOB streamed data
    > through ADO in code.
    For classic ASP:

    [url]http://support.microsoft.com/default.aspx?[/url]
    scid=http://support.microsoft.com:80/support/kb/articles/Q173/3/08.asp&NoWe
    bContent=1

    [url]http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=172[/url]


    --
    Lucas Tam (REMOVEnntprogers.com)

    Kodak DC240 Digital Zoom Camera w/ EXTRAs for Auction! 99c!
    [url]http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=2937992463[/url]
    Lucas Tam Guest

Similar Threads

  1. how to view a BLOB (image)
    By shahzad in forum Coldfusion Database Access
    Replies: 2
    Last Post: June 21st, 10:39 PM
  2. How to show an image on my page
    By Krechting in forum ASP Database
    Replies: 7
    Last Post: December 29th, 04:15 PM
  3. BLOB Image from Interbase in ASP
    By Ray at in forum ASP Components
    Replies: 10
    Last Post: October 24th, 05:16 PM
  4. BLOB Image fron Interbase in ASP....
    By Ray at in forum ASP Database
    Replies: 1
    Last Post: October 23rd, 04:58 PM
  5. determine image information on image stored in MySQL BLOB
    By kristofl in forum PHP Development
    Replies: 2
    Last Post: October 4th, 01:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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