Professional Web Applications Themes

Sql Image Data - Microsoft SQL / MS SQL Server

Greg, Assume for simplistics that I have a Table called ClassifiedAds and another called BannerAds, which both need images. I have to have a ClassifiedAdID (Nullable) and a BannerAdID (Nullable) in the IMAGES table so that I know what image record belongs to what record in the parent table. I have multiple tables pointing to a central IMAGES table instead of having a table called ClassifiedAdImages and another called BannerAdImages. See the dimlemma?? Please reply. Thanks, Peter *** Sent via Developersdex [url]http://www.developersdex.com[/url] *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default Re: Sql Image Data

    Greg,

    Assume for simplistics that I have a Table called ClassifiedAds and
    another called BannerAds, which both need images. I have to have a
    ClassifiedAdID (Nullable) and a BannerAdID (Nullable) in the IMAGES
    table so that I know what image record belongs to what record in the
    parent table. I have multiple tables pointing to a central IMAGES table
    instead of having a table called ClassifiedAdImages and another called
    BannerAdImages. See the dimlemma?? Please reply.

    Thanks,
    Peter


    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Peter Albanese Guest

  2. #2

    Default Re: Sql Image Data

    Peter,
    I have a head cold at the moment so things are a bit slow.
    I still don't see why you need multiple keys . The image table had one key.
    This can be used an any number of other tables ie ClassifiedAds and/or
    BannerAds. I don't see why you need multiple keys. In plan text an image
    can belong to many BannerAds and ClassifiedAds

    regards
    Greg O





    "Peter Albanese" <anonymousdevdex.com> wrote in message
    news:uQxxDyqRDHA.1920TK2MSFTNGP11.phx.gbl...
    > Greg,
    >
    > Assume for simplistics that I have a Table called ClassifiedAds and
    > another called BannerAds, which both need images. I have to have a
    > ClassifiedAdID (Nullable) and a BannerAdID (Nullable) in the IMAGES
    > table so that I know what image record belongs to what record in the
    > parent table. I have multiple tables pointing to a central IMAGES table
    > instead of having a table called ClassifiedAdImages and another called
    > BannerAdImages. See the dimlemma?? Please reply.
    >
    > Thanks,
    > Peter
    >
    >
    > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    > Don't just participate in USENET...get rewarded for it!

    Greg Obleshchuk Guest

Similar Threads

  1. Image data parsing
    By anatolym in forum PERL Modules
    Replies: 1
    Last Post: October 30th, 10:39 AM
  2. Nasa raw image data
    By f.lopez in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 4
    Last Post: August 24th, 07:47 PM
  3. EXIF data in JPG image
    By Don in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 0
    Last Post: July 24th, 01:27 PM
  4. Streaming Image data to an image viewer
    By Jerry J in forum ASP.NET General
    Replies: 0
    Last Post: July 18th, 01:33 PM
  5. copying image data
    By RP in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 7th, 06:09 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139