+ Reply to Thread
Results 1 to 6 of 6
  1. #1
    Member
    Join Date
    Jun 2001
    Location
    England
    Posts
    41

    Saving images from database fields to files

    I currently have a database with images stored in a image field.

    I can view these using an asp page, but i also need to extract them into files, for example the picture is car1 in db needs to be extracted to car1.jpg.

    does anyone know the code that i can use

    Thanks

  2. #2
    Banned qball's Avatar
    Join Date
    Oct 1999
    Location
    Rockaway, NJ 07866
    Posts
    1,730
    how do you view in ASP?

  3. #3
    Senior Member
    Join Date
    May 1999
    Location
    Denver, CO, USA
    Posts
    775
    I know this doesn't answer your question, but now you've got me wondering. What type of database are you using? I've never heard of an image db.

    thx
    -Z

  4. #4
    Member
    Join Date
    Jun 2001
    Location
    England
    Posts
    41
    I am using Filemaker, I know you can use Access and SQL to do the same, but i don't require that at the moment.

    To use Filemaker image information i just use the BinaryRead asp command.

    To function in Access or SQL i think it is pretty much the same thing but slightly more involved, and i haven't looked into it yet.

  5. #5
    Banned qball's Avatar
    Join Date
    Oct 1999
    Location
    Rockaway, NJ 07866
    Posts
    1,730
    BinaryRead streams the file to the browser in the default MIME type.

    Try:
    http://www.asplists.com/listserv/arc...inaryfiles.asp

  6. #6
    Banned qball's Avatar
    Join Date
    Oct 1999
    Location
    Rockaway, NJ 07866
    Posts
    1,730
    The example I have posted above, inherently shows how to retrieve the file from the DB into memory. Once in memory, and hopefully the file type is known, then save to file with proper extension, right?

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







New Security Features Planned for Firefox 4
Another Laptop Theft Exposes 21K Patients' Data
Oracle Hits to Road to Pitch Data Center Plans
Microsoft Preps Array of Windows Patches
Microsoft Nears IE9 Beta With Final Preview
Simplified Analytics Improve CRM, BI Tools
Android Passes RIM as Top Mobile OS in 2Q
VMware Updates Hyperic System Management
File Monitoring Key to Enterprise Security
LinkedIn Snaps Up SaaS Player mSpoke