Get more than one row from a column

Hello experts.
On my question on this site:
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_23269582.html
I have solution from angelli :
<cfquery name="List_test_column" datasource="carfree24">
SELECT a.artikel_ID ,a.test_column ,test.test_Text
FROM dbo.artikel a,test
where Artikel_ID=1
and ',' + a.test_column + ',' LIKE '%,' + cast(test.test_ID as varchar(20)) + ',%'
<c/fquery>.
The tables are:
I have in a table (artikel) and column (test_column) values in form:
artikel_Id       test_column
1                   10,20,30,40,50,60,70
2                   20,30,60,70,80,90..............
In a second table (test) and column(test_text):
test_ID            test_Text
10                    text1
20                    text2
30                    text3..................
The output:
<cfoutput>#List_test_column.test_Text#</cfoutput>
The problem is that i get in the browser only one text as result
(When i test the query i get a result:
1 text1
2 text2
3 text3
4 text4........
I want a result :text1,text2,text3,textt4.....
Any help?Start Free Trial