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

  1. #1

    Default Unique Record

    I've forgotten how to do this.

    I have multiple UPC codes in a document, but I just want to write each of them
    once when I output.
    What's the command to only use one of a specific record kind.

    it's like select unique, or something ilke that....



    keller18 Guest

  2. Similar Questions and Discussions

    1. Unique Form inserting into many tables using unique id
      I have a Registration Form that have 3 steps. The data could be inserted into many (4) tables. Some data corresponding to a one table (the main or...
    2. value list with unique options by current record
      How can I make a value list to which I can add not only to the whole list by checking the possibility to show "edit", but also add options stored...
    3. Stop adding record in subform after record count = 1
      Can someone help in in what to put after the THEN statment to allow one entry if the Record count is =>1 in the Before insert or should I set the...
    4. Adding a new record when the record source is a query.
      Hello All, I have a form that runs a query. The reason it runs on a query is because prior to it opening I have a form from which you can pick...
    5. dbExport : 100 - ISAM error: duplicate value for a record with unique key.
      Hi, I tried to do a dbexport of my informix database and I received this error: 100 - ISAM error: duplicate value for a record with unique key....
  3. #2

    Default Re: Unique Record

    select distinct
    Dan Bracuk 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