Results 1 to 6 of 6

Thread: Create BLOB's Image Thumbnail

  1. #1

    Thread Starter
    Frenzied Member Tec-Nico's Avatar
    Join Date
    Jun 2002
    Location
    México
    Posts
    1,192

    Create BLOB's Image Thumbnail

    After searching through the forums it seems there is no topic discussing how to create a thumbnail of a picture you store into a BLOB Field in Access...

    Is there a way to create a thumbnail of a picture stored in a MSSQL (or Access' OLE Object) BLOB?

    I was wondering if when storing the picture into the DB you can manipulate the data to make a thumbnail (using an algorithm to create it, of course) and store it into a different field or if when retrieving the data from the field to manipulate the stream and turn it into a thumbnail before displaying it?

    Thanks in advance for your replies
    We miss you, friend... Rest in Peace, we will take care of the rest of it.

    [vbcode]
    On Error Me.Fault = False
    [/vbcode]
    - Silence is the human way to share ignorance
    Tec-Nico

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: Create BLOB's Image Thumbnail

    The reason for no threads about it is that creating thumbnails should not be done on the database side - it should be done with the image itself.

    The reason for this is that there are many picture file formats, and the SQL commands to work with it would be horrendous, and probably very inefficient too.


    If the thumbnails are likely to be used relatively regularly (and more than the 'full' image), then storing them in the database is a good idea, as long as you can cope with the size of the extra blob field (Access may have issues).


    Depending on how you are uploading the original pictures, it is likely to be best to create the thumbnail at the same time. Otherwise you will need to extract the image from the database in order to create the thumbnail.

  3. #3

    Thread Starter
    Frenzied Member Tec-Nico's Avatar
    Join Date
    Jun 2002
    Location
    México
    Posts
    1,192

    Re: Create BLOB's Image Thumbnail

    Thanks for your answer, si. In case I would like to create the thumbnail when uploading the original picture, how would I do that?

    I know that doing it with SQL would be horrible, it didn't deserve any thought from my part.

    The thumbnails are going to be used regularly since they would be images of a product catalog. Right now I just have code to store and display the BLOB and would appreciate some advice.
    We miss you, friend... Rest in Peace, we will take care of the rest of it.

    [vbcode]
    On Error Me.Fault = False
    [/vbcode]
    - Silence is the human way to share ignorance
    Tec-Nico

  4. #4
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: Create BLOB's Image Thumbnail

    I'm not really the one to answer that, however this thread should have the answer for you:
    http://vbforums.com/showthread.php?s=&threadid=237900

  5. #5

    Thread Starter
    Frenzied Member Tec-Nico's Avatar
    Join Date
    Jun 2002
    Location
    México
    Posts
    1,192

    Re: Create BLOB's Image Thumbnail

    Thank you, I just went there and checked the code. It is an interesting piece of code but then I wonder if it is possible to do that in an ASP page.

    Are you allowed to call API from ASP? I am not sure about that.
    We miss you, friend... Rest in Peace, we will take care of the rest of it.

    [vbcode]
    On Error Me.Fault = False
    [/vbcode]
    - Silence is the human way to share ignorance
    Tec-Nico

  6. #6
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: Create BLOB's Image Thumbnail

    I've got no idea, it's worth a try.

    You'd have to ask in the ASP forum to get an accurate answer.

Posting Permissions

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



Click Here to Expand Forum to Full Width