Professional Web Applications Themes

Pulling alternate image from DB?? - Macromedia ColdFusion

I have a customer who would like a 'alternate' picture displayed of a couple of their products. The product info and image locations are both stored in a MySql db, and when users choose a particular product, obviously the information is pulled for the necessary tables. I'm curious if it would be best to add a 'alternate' table column, and the picture URL or if there is a better way? Also, once the URL (or more if there are going to be more 'alternate' pictures) is added, how can you code Coldfusion to step through the listing of URL's for ...

  1. #1

    Default Pulling alternate image from DB??

    I have a customer who would like a 'alternate' picture displayed of a couple of
    their products. The product info and image locations are both stored in a
    MySql db, and when users choose a particular product, obviously the information
    is pulled for the necessary tables. I'm curious if it would be best to add a
    'alternate' table column, and the picture URL or if there is a better way?
    Also, once the URL (or more if there are going to be more 'alternate' pictures)
    is added, how can you code Coldfusion to step through the listing of URL's for
    the 'alternate' product pictures, and display them. Would a isDefined work?
    Thanks, Steve

    SteveG144 Guest

  2. #2

    Default Re: Pulling alternate image from DB??

    If you want to add one or more alternate pictures the setup of a new table is
    a good option. It chould include the key from the product table and simply the
    URL to the alternate picture. This way you can add none or as many alternates
    you like. It's also easy to list all the alternates for the selected product.
    Example: Product table: -------------------- ProductID (primary key)
    ProductName ..etc New Table: -------------------- ID (primary key, often good
    to have here too but not necessary) ProductID AlternatePicture : Stg

    sTg Guest

Similar Threads

  1. asp alternate row color
    By Russ in forum Dreamweaver AppDev
    Replies: 2
    Last Post: April 26th, 03:18 AM
  2. Pulling images on the fly
    By walter@whardy.com in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: April 17th, 04:41 PM
  3. Alternate location for php.ini
    By Artco News in forum PHP Development
    Replies: 15
    Last Post: November 5th, 04:46 AM
  4. Using alternate web servers
    By Nida Farid in forum ASP.NET Web Services
    Replies: 1
    Last Post: August 23rd, 12:05 AM
  5. alternate SQL in asp page
    By Raphael Gluck in forum ASP
    Replies: 10
    Last Post: August 10th, 07:27 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