JPG stored as long binary in database: how to write output as image in asp?

Discussion in 'ASP General' started by bart plessers, Sep 30, 2003.

  1. Hello,

    For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as
    manager for pics.
    The benefit of the program is that it stores all kind of information in a
    central Microsoft Database that easily can be manipulated.
    A thumbnail of the picture is also stored in de MDB as long binary (jpeg
    format)

    I made a small script that extracts all kind of information of the MDB by
    use of queries and ASP.
    This works perfect for string/numerical information.

    I am wondering if I can also write the stored (jpg)thumbnail to the asp file
    so that I have a preview of my picture.

    Can this be done? What is the syntax?
    I tried already :

    Response.BinaryWrite BinData

    Where BinData is the contents of the Thumbnail field.
    When I take a look at the MDB table in design view, the DataType of this
    field is "OLE object", if I open the table, the contents of the field
    displays "long binary data".

    Has anybody an idea?

    any help is appreciated!

    tia
    bartp

    --

    ==========================================
    Hyper A.R.T.
    bart plessers
    Paul Van Ostaijenlaan 4
    3001 Heverlee
    BELGIUM
    tel: +32 (16) 23.40.85
    fax: +32 (16) 23.41.06
    ==========================================
    bart plessers, Sep 30, 2003
    #1
    1. Advertising

  2. bart plessers

    Tom B Guest

    http://www.aspfaq.com/show.asp?id=2149

    The third to last point is relevant to you. It refers you to some microsoft
    documents regarding extracting the ole data.

    Essentially, though, you'd create your page as normal with a reference in it
    to a second page that returns the image. For example:

    page1....

    <img src="Page2.asp?PicID=99">


    page2.asp

    <%
    Response.BinaryWrite........etc.

    %>


    "bart plessers" <> wrote in message
    news:...
    > Hello,
    >
    > For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as
    > manager for pics.
    > The benefit of the program is that it stores all kind of information in a
    > central Microsoft Database that easily can be manipulated.
    > A thumbnail of the picture is also stored in de MDB as long binary (jpeg
    > format)
    >
    > I made a small script that extracts all kind of information of the MDB by
    > use of queries and ASP.
    > This works perfect for string/numerical information.
    >
    > I am wondering if I can also write the stored (jpg)thumbnail to the asp

    file
    > so that I have a preview of my picture.
    >
    > Can this be done? What is the syntax?
    > I tried already :
    >
    > Response.BinaryWrite BinData
    >
    > Where BinData is the contents of the Thumbnail field.
    > When I take a look at the MDB table in design view, the DataType of this
    > field is "OLE object", if I open the table, the contents of the field
    > displays "long binary data".
    >
    > Has anybody an idea?
    >
    > any help is appreciated!
    >
    > tia
    > bartp
    >
    > --
    >
    > ==========================================
    > Hyper A.R.T.
    > bart plessers
    > Paul Van Ostaijenlaan 4
    > 3001 Heverlee
    > BELGIUM
    > tel: +32 (16) 23.40.85
    > fax: +32 (16) 23.41.06
    > ==========================================
    >
    >
    >
    >
    >
    >
    Tom B, Sep 30, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Roland
    Replies:
    0
    Views:
    1,056
    Roland
    May 12, 2004
  2. Matthias
    Replies:
    5
    Views:
    427
    Whitecrest
    Jun 1, 2004
  3. AAaron123
    Replies:
    0
    Views:
    1,047
    AAaron123
    Jul 29, 2009
  4. bart plessers
    Replies:
    0
    Views:
    120
    bart plessers
    Sep 30, 2003
  5. Yannick

    ASP changes Big JPG -> Small JPG

    Yannick, Feb 2, 2004, in forum: ASP General
    Replies:
    6
    Views:
    152
    Tim Williams
    Feb 3, 2004
Loading...

Share This Page