Posting an image as a database result.


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Posting an image as a database result.

  1. #1
    Chris Guest

    Posting an image as a database result.


    Can and will anybody help a beginner by giving me a solution. I need to post
    an image as either a database field or as a link from a db field using access,
    FrontPage 2k and ASP

  2. #2
    Phil Guest

    Re: Posting an image as a database result.


    [ Reply]

    I was looking for an answer to my question and found what looks
    like the answer to your question....here it is...

    /Phil

    --------

    Re: Database in ASP
    FPUG Discussion
    From: auction@westauction.com
    Date: 4/27/00
    Time: 12:19:38 PM


    Comments
    Here is a copy of some useful info put out by MS. It worked for me. Write
    if you need help understanding what happens.

    Display an Image Using Data from a Database:

    With FrontPage 2000, you can use information from a field in a database to
    display images on your Web page.

    The sample database contains a column called Image. This field contains a
    file name for an image. You can use this information to display this image.


    NOTE: Three images that you can use for this example are located in the Images
    folder. They are animal1.gif, animal2.gif, and animal3.gif.

    To display an image using data from a database, follow these steps:

    Create a new page, and name it "displayimages.asp" (without the quotation
    marks).


    On the Insert menu, point to Database, and click Results.


    In Step 1 of the Database Results Wizard, click the Use an existing database
    connection button, and click to select Volcano2 from the list. Click Next.



    In Step 2 of the Database Results Wizard, make sure the Record Source option
    is selected and Employees is selected from the list. Click Next.


    In Step 3 of the Database Results Wizard, click Edit List.


    In the Displayed Fields dialog box, click to select all of the items in the
    Displayed Fields list except for First Name, LastName, and Image, and click
    Remove.


    In Step 4 of the Database Results Wizard, click Next.


    In Step 5 of the Database Results Wizard, click to select the Display all
    records together option, and click Finish.


    Locate the database column value that reads "<<Image>>" and delete it.


    In the table cell that you just removed the column value from, insert the
    animal1.gif picture from the images folder by using the Picture command on
    the Insert menu. This places the lion image in the table.


    Right-click the image you just inserted, and click Picture Properties.


    Under Picture Source, click Browse, and then click Parameters.


    In the path field, remove the current path and then click Insert Field Parameter
    and select Image.


    Click OK three times. You see a small broken image icon in the column under
    PicName.


    Save the page as show.asp on the File menu.




    "Chris" <chris@hildebran.com> wrote:
    >
    >Can and will anybody help a beginner by giving me a solution. I need to

    post
    >an image as either a database field or as a link from a db field using access,
    >FrontPage 2k and ASP



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center