Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > JPG stored as long binary in database: how to write output as image in asp?

Reply
Thread Tools

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

 
 
bart plessers
Guest
Posts: n/a
 
      09-30-2003
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
==========================================






 
Reply With Quote
 
 
 
 
Tom B
Guest
Posts: n/a
 
      09-30-2003
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> ==========================================
>
>
>
>
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How include a large array? Edward A. Falk C Programming 1 04-04-2013 08:07 PM
Having compilation error: no match for call to (const __gnu_cxx::hash<long long int>) (const long long int&) veryhotsausage C++ 1 07-04-2008 05:41 PM
Wrong image size of JPG after TIFF to JPG conversion with JAI Roland Java 0 05-12-2004 03:52 PM
Looking for software to combine 4 JPG images into one JPG image G.M. Durrence Digital Photography 4 04-08-2004 08:04 PM
output jpg stored in database as long binary to asp: how? bart plessers ASP General 0 09-30-2003 12:41 AM



Advertisments