Loop through resultset and add create comma seprated string in ASP Classic
- by Sam
Here's my ASP Classic:
set irs = recordset(sql,PageDB)
if not irs.eof then
dim new_list
new_list = ""
do while not irs.eof
'Add irs("name") to new_list and seperate by comma
irs.movenext
loop
end if
kill(irs)
How would I add irs(name) to new_list and seperate by a comma?