Preferably, you can move the array to getrows, then use join()

Or, if you really want to loop, you could build a string:

str = str & rs("TrackName") & ", "

Then once you're outside of the loop,

response.write left(trim(str), len(trim(str))-1)

> If Not rs.EOF And Not rs.BOF Then
> do while not rs.eof
> Response.Write rs("TrackName") &", "
> rs.movenext
> Loop
> Else
> Response.Write "No Data"
> End If
>
> The thing is I do not want to show the last comma, when the last record is
> displayed - either display full stop or nothing at all
> How can I get resolve this issue?
>
> cheers for all help
> matt
>
>