Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002

    Unanswered: Storing Image Links in DB - - is it dynamic?

    I know people have posted about similar topics before but I have one small q...

    I am designing a database on which you can search for (using ASP)/download/upload txt files, sound files & pictures..

    It is clear that if you are storing even a moderate amount of sound files/pics you're better off storing a link to the file in the DB & actually store it ok with that


    if i store a link to them (ie. to a spot on a server) is it possible for my web page to be dynamic??

    ie. if someone uploads an image will it be there straight away for another person to download it...???

    also is it possible to search for these files by name (ie. by band name in my case) if they are not actually stored in the DB?

    Any input would be greatly appreciated..


  2. #2
    Join Date
    Nov 2002
    does anyone have any idea about my question above??

    The ability for it to be dynamic & for you to be able to search for sound files/image files of specific bands is integral to my project...


  3. #3
    Join Date
    Nov 2002

  4. #4
    Join Date
    Sep 2002
    Provided Answers: 1
    Originally posted by Philby_Walsh
    Well, this is out of my normal field so I'm hesitant to respond. but since no one else has come forward yet...

    I would expect your database to hold all the necessary information for searching for files. e.g.

    Table FILE
    ( file_name
    , file_type /* sound, picture etc. */
    , band_name
    , description
    , size
    , etc. /* any other information useful for searching */
    , link to external file

    So the user will search the database for the FILEs they are interested in, and when they select one your app will use the link to get the external file to upload.

    Does that sound reasonable?

  5. #5
    Join Date
    Apr 2002
    California, USA


    Your application can store both the URL to the uploaded file as well as the name, author, type, size, etc. in Oracle table. As soon as your user click Submit button, you upload the file, commit the transaction and then the rest of the users can see it when they query this table.

    Once the data is in the db, you can slice and dice the data the way you like it: WHERE tittle LIKE upper('%yellow') , author LIKE upper('metallica'), etc.

    Hope that helps,

    OCP - DBA

Posting Permissions

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