如何去掉ASP里的逗号

31, 32, 33, 34, 35, 36

我想一个一个读取出来，要怎么做

读取出来的数是31 32 33 34 35 36

for i to 6

set rs=conn.execute("select * from product id="&提取出来的ID)

next

请问下要怎么写，代码照着这个来写，别的我看不懂

何必一定要提取出来呢

set rs=conn.execute("select * from product id in(31, 32, 33, 34, 35, 36))

num="31, 32, 33, 34, 35, 36"

set rs=conn.execute("select * from product where id in "&num)

如果你想一个一个读取出来，就要用split函数

num="31, 32, 33, 34, 35, 36"

arynum= Split(num,", ")

For i= 0 To Ubound(arynum) response.write arynum(i)

Next