Multiple rows of data into 1 row

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

  1. #1

    Default Multiple rows of data into 1 row

    I have a Pt ID field which is a unique number. I have a S_field which is an
    ID # that lines to the Pt ID. There are multiple Pt ID's for one S_field ID.
    When I make the report, it puts each separate S-field on a different line.
    Is it possible to get all the Pt ID's associated with 1 S_field to be in 1
    row.

    It would look like S-Field Pt ID
    31 1,2,3,4


    Chip Jones Guest

  2. Similar Questions and Discussions

    1. Getting data from multiple rows into a list
      I have a table that has values as follows: PersonID Degree 55 MD 55 Phd 55 RN 60 MD...
    2. Selecting Multiple Rows from DB
      I'm building code where I need to be able to read all the rows in a single column of data. My SQL code currently is simple and looks like this: ...
    3. Update multiple rows data with a single button
      hello I have been trying to run multiple update queries based on the data entered by user. Brief background: I am fetching data from various...
    4. Display 1 data row as multiple datagrid rows
      If a row of data in a dataset has a lot of columns the row displaying the data in a datagrid will run way off the screen. What I'd like to do is...
    5. How would I insert multiple rows of data from one form?
      Dear ASP.NETers, How would I insert multiple rows of data from a web form? Are there any tute's and stuff around. Couldn't find any myself. ...
  3. #2

    Default Re: Multiple rows of data into 1 row

    Use the group attribute in the cfoutput tag. The cfml reference manual has an example. If you don't have one, the internet does.
    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