Android Question Word (arraylist) is showing up messagebox

[anaylor01]

Please take a look at the image and tell me how I can remove the (arraylist) and Brackets from the message box. The code is below.

aList.Initialize()   
Dim cursor As Cursor
cursor=SQL1.ExecQuery("select TeamName from GamePlay")
For i = 0 To cursor.rowcount -1
cursor.position = i
aList.add(cursor.getstring("TeamName"))
Next
Msgbox(aList & " have tied.","Tie Game")
btngameplay.Text = "Team " & SQL1.ExecQuerySingleResult("SELECT  teamname FROM GamePlay where ID = '" & tid & "'") & " START"

 

[mangojack]

try this ...

Msgbox(aList.Get(0) & " & " & aList.Get(1)  & " have tied.","Tied Game")

OR smart string literal ... https://www.b4x.com/android/forum/threads/b4x-smart-string-literal.50135/#content

Msgbox($" ${aList.Get(0)}  &  ${aList.Get(1)}  have tied. "$,"Tied Game")

 

[anaylor01]

Maybe you can help me with this. There can be between 2 and 10 ties. How would I do that?

 

[anaylor01]

That is why I was using a list.

 

[anaylor01]

Here is how I fixed it.

Dim cursor As Cursor
Dim tienames As String
cursor=SQL1.ExecQuery("select TeamName from GamePlay")
For i = 0 To cursor.rowcount -1
cursor.position = i
tienames =  tienames & cursor.getstring("TeamName") & " and "
Next
tienames = tienames.SubString2(0,(tienames.Length -4))
Msgbox(tienames  & " have tied.","Tied Game")

 

[Mahares]

You could have also used stringbuilder like this:

Dim sb As StringBuilder
    sb.Initialize
    For i = 0 To cursor.rowcount -1
        cursor.position = i
        sb.Append(cursor.getstring("TeamName")).append(CRLF)
    Next
    Msgbox(sb.ToString,"Tied Teams")