7,763
社区成员
发帖
与我相关
我的任务
分享
/*
就是把strSql这个SQL语句查询换成我自己写的存储过程查询 [存储过程名 Msha_DuiHuaR 参数 @uin int ]
存储过程返回值是一条数据,谁帮我改下?
*/
...
dim rs,strSql
strSql = "select * from V_UserByUIN where UIN= " &uin
set rs = server.createobject("adodb.recordset")
set rs = conn.execute(strSql)
If Not rs.EOF And Not rs.BOF Then
telId = rs("telUserNum")
nick = trim(rs("name"))
if nick = "" then
nick = uin
end if
if userStatus = "" then
if rs("bOnline") < 10 then
userStatus = 3
else
userStatus = 1
end if
end if
title = rs("title")
postcode = rs("postcode")
address = rs("address")
corp = rs("company1")
tel = rs("tel")
fax = rs("fax")
Product = rs("Product")
userPicpath = rs("Picpath")
session("noteUIN") = rs("noteUIN")&""
session("notePWD") = rs("notePWD")&""
session("tel") = rs("smobile")&""
note = rs("dxsf")
End If
rs.close
...
set rs = server.createobject("adodb.recordset")
rs.Open "Exec Msha_DuiHuaR "&uin,conn