Show particular data only once

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Show particular data only once

    Hi,

    I'm busy putting a product DB/site together. When a product is selected (for
    instance Adobe Acrobat), you go to a details.cfm page.

    On this page I want one boxshot, one global description and below the
    different versions, like Win/Mac, Upgrade/Full, prizes etc.
    What I have now is a table which gets filled with all the data, but I like I
    said I only need one description and picture. The one in the first record would
    be fine.
    How do I do this ?

    This is what I've got now, the bold parts are the picure and description.

    <cfoutput query="website">
    <cfif website.currentrow mod 2 eq 1>
    <tr>
    </cfif>
    <td valign="top" align="center" width="100">
    <img src="webpictures/#WEBPICTURE#">
    </td>

    <td> <span class="style5">#website.productname#</span><BR>
    <div align="right"><strong>Prijs</strong>:
    #LSEuroCurrencyFormat(website.srp_eur)#</div><br>
    <!---//niet aanwezig <strong>Ontwikkelaar</strong>: #ontwikkela#<br>--->
    <strong>Platform</strong>: #website.platform# <br>
    <strong>Omschrijving</strong>: #website.webomschrijving_NL_lang#<br><br>
    <strong>Systeemeisen</strong>: #website.systeemeisen#<br><BR>
    <div align="right"><strong>Prijs</strong>:
    #LSEuroCurrencyFormat(website.srp_eur)#</div>

    <BR><BR>
    <div align="right"><a href="javascript:history.go(-1)">[<-Vorige]</a></div>

    <hr>

    </td>
    <cfif website.currentrow mod 2 eq 1>
    <tr>
    </cfif>
    </cfoutput>

    Funkert Guest

  2. Similar Questions and Discussions

    1. Query to show data but ignore dupes
      i have a database with 500,000 records. one column has the same data over and over. i am trying to get a list of the differnt names in that one...
    2. Datagrid doesn't show data, although it's there ?
      Hi, I've read the Business Directory Sample Tutorial from the Macromedia website, and I've set up my own MySQL database, with some modifications....
    3. how to use datagrid & actionscript to show data
      hi all, I have a project , which needs to be done entirely in Flash. It should have a product comparison table.When we click on a image and drag...
    4. Entering Data and then having another linked data show up.
      I am creating a form. What I need help doing is setting up the following. First, I have a list box with about 12- 15 options to choose. Each of...
    5. can't get data to show with bound columns
      I'm trying to create a DataGrid filled with values from a DataSet and I want the user to be able to show and hide whichever columns they choose. I...
  3. #2

    Default Re: Show particular data only once

    You could initialize a flag to TRUE before entering the loop; then test the
    flag when you are ready to display the picture and description. If the flag is
    TRUE (first time), you do the display and set the flag to FALSE.

    jdeline Guest

Posting Permissions

  • You may not post new threads
  • You may 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