Problem combing multiple lists into one

[mourning2night]

I have three lists (m1,m2,m3) and I need to combine them into one list (m4):

<cfset m1 = valuelist(search2.cat)>
<cfset m2 = valuelist(search2.cat2)>
<cfset m3 = valuelist(search2.cat3)>

<cfset m4 = m1 & m2 & m3 >
<cfset m4 = listsort(m4,"text")>

That works fine but some of the values are mixed up.

List One = A, B, C
List Two = D, E, F
List Three = G, H,I

Combined List = A, B, CD, E, FG, H, I

The Value C get added to the next line D, and value F gets added to the next
line G.
How can I separate end values of each list?

[Kronin555]

What you need to do, instead of just concatenating them together, is use
ListAppend.

If you change:
<cfset m4 = m1 & m2 & m3>
to
<cfset m4 = ListAppend(m1,ListAppend(m2,m3))>
then you'll be good to go.

A list in ColdFusion is just a glorified string. m1 just contains "A,B,C", so
when you do the concatenation (&), coldfusion doesn't have any idea that you
actually want it to put a list separator in between the 2 lists ("strings")
that you are concatenating.