这个用二维数组怎么做!!!!??
数据表显示如下:
ID Names pathname
1 A*B*C a,b,c*d*e,f,g,h
<%
set conn=server.CreateObject("ADODB.Connection")
conn.open "Driver={Microsoft Access Driver (*.mdb)};dbq="&server.mappath("test.mdb")
set rs=server.createobject("ADODB.Recordset")
sql="select * from testsplit where id='1'"
rs.open sql,conn,3,3
split2=split(rs("names"),",",-1)
split3=split(rs("namepath"),"*",-1)
for i=0 to ubound(split2)
response.write split2(i)&":<br>"
split4=split(split3(i),",",-1)
for n=0 to ubound(split4)
response.write split4(n)&"<br>"
next
next
%>
我上面的代码可以输出如下结果:
A:
a
b
c
B:
d
C:
e
f
g
h
怎么样用二维数组来简化我上面的程序