Displaying a column comprised of concatenated data from other columns
Displaying a column comprised of concatenated data from other columns
LCharlier
Posts: 4Questions: 2Answers: 0
If I have a database table containing discrete address fields (e.g. addr_line1, addr_line2, city, state, zip), can I display a record's address in the datatable as a multiline concatenation of all these database fields (each discrete field displayed in the same column separated by a "\n") while not displaying the individual fields as columns?
This question has an accepted answers - jump to answer
Answers
See this exampel which shows how to combine multiple columns into one.
HTML uses
<br>, not\n, as the line break. Just insert the linebreak into the string where appropriate.Kevin
Kevin - With your assistance, I was quickly able to get everything just the way I wanted. Thanks for pointing me in the right direction! Much appreciated.
Lloyd