28,391
社区成员
发帖
与我相关
我的任务
分享
<%
function f1(user)
redim arrs(k)
k=0
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from buyer where users='"&user&"'",conn,1,1
do while not rs.eof
if rs("buyer")<>"" then
arrs(k)=rs("buyer")
k=k+1
end if
rs.movenext
loop
f1=arrs
rs.close
set rs=nothing
end function
%>
<%
function f1(user)
dim arr()
k=0
set rs=server.CreateObject("adodb.recordset")
rs.cursorLocation = 3
rs.open "select * from buyer where users='"&user&"'",conn,1,1
redim arr(rs.recordCount-1)
do while not rs.eof
if rs("buyer") <>"" then
arrs(k)=rs("buyer")
k=k+1
end if
rs.movenext
loop
f1=arrs
rs.close
set rs=nothing
end function
%>
<%
dim ss
ss=f1("admin")'这个ss就是数组了
function f1(byval user)
dim s
set rsGXQ323=conn.execute("select * from [buyer] where [users]='"&user&"'")
do while not rs.eof
if len(rsGXQ323("buyer")&"")>0 then
if len(s)=0 then s=rsGXQ323("buyer")&"" else s=s&"|||"&rsGXQ323("buyer")&""
end if
rsGXQ323.movenext
loop
rsGXQ323.close
set rsGXQ323=nothing
if len(s)>0 then
f1=split(s,"|||")
else
f1=Array("无数据")
end if
end function
%>