求一asp遍历数组！！

[叽叽复叽叽]

上一页：bigclassname=aa,bb,cc
下页：
BigClassName=trim(request.form("BigClassName"))
dim a()=split(BigClassNames,",")

这是从上一个页面返回的字符，我想截取该字符串，并存到sql语句中，求高手帮我遍历下，我都懵了。。。

[Dogfish]

BigClassName=trim(request.form("BigClassName"))
a=split(BigClassNames,",")
for i=0 to ubound(a)
   response.write a(i)
next

[明珠佩佩]

Dim BigClassName
BigClassName=trim(request.form("BigClassName"))

Dim a, i
a=split(BigClassNames,",")
for i=0 to ubound(a)
   response.write a(i)
next

[晓风拂月]

[Quote=引用 2 楼 bimyboy 的回复:]
VBScript code


Dim BigClassName
BigClassName=trim(request.form("BigClassName"))

Dim a, i
a=split(BigClassNames,",")
for i=0 to ubound(a)
response.write a(i)
next
[/Quote]+1

[hongmei85]

BigClassName=trim(request.form("BigClassName"))

sql = "select * from tt where [BigClassName] in('"& replace(BigClassName,",","','") &"')"

[叽叽复叽叽]

谢谢大家。。我看懂了！！！