Ask a Question related to Coldfusion Database Access, Design and Development.
-
Chip Jones #1
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
-
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... -
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: ... -
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... -
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... -
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. ... -
Dan Bracuk #2
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



Reply With Quote

