I have a database table with three columns containing numbers.
Column 1
123
456
789
Column 2
987
654
321
Column 3
24680
13579
Would like to display in one column …
123
456
789
987
654
321
13579
24680
Is this possible?
I have a database table with three columns containing numbers.
Column 1
123
456
789
Column 2
987
654
321
Column 3
24680
13579
Would like to display in one column …
123
456
789
987
654
321
13579
24680
Is this possible?
I might well be missing the point, but can’t you simply put:
{{col1}}<br>{{col2}}<br>{{col3}}
into the single column.
(I’m not sure if you’re referring to database table columns or HTML table columns - but it may not make any difference.)
Ah, yes, its a database table.
But the display part - that’s an HTML table? (I’m not sure if you have a solution yet.)
assuming that the table is a SQL database table to assemble the 3 columns into a single list or column can assembled using a UNION query
select col1 from table1
union
select col2 from table1
union
select col3 from table1
Thanks Jeffrey! I have never used UNION before. I will experiment with that today.
Much appreciated.
That’s already possible using the Server Connect Array List component:
This topic was automatically closed after 26 hours. New replies are no longer allowed.