高手帮个忙，数组操作数据库的问题，在线等~~
<table>
<%
toname = split(session( "padname "), ", ")
for i=0 to ubound(toname)
set rsp = server.CreateObject( "adodb.recordset ")
sqlp = "select mbno from oa_user where name= ' "&toname(i)& " ' "
rsp.open sqlp,conn,1,1
%>
<tr>
<td > <%=toname(i)%> <%=rsp( "mbno ")%> </td>
</tr>
<% next %>
</table>
---------------------------------------------------
运行以后为什么rsp( "mbno ")只能取到第一即toname(0)时的数据阿？其他都是空的。。
[解决办法]
sqlp = "select mbno from oa_user where name= ' "& trim(toname(i)) & " ' "
