Dim oCmd
Dim oRs
Set oCmd = Server.CreateObject("ADODB.Command")
set oCmd.ActiveConnection = conn
oCmd.CommandText = "check_son"
oCmd.CommandType = 4
oCmd.Prepared = true
set Param1 = oCmd.CreateParameter ("@userID1",adChar ,adParamInput ,16,userid1)
oCmd.Parameters.Append Param1
set oRs = oCmd.Execute
dim str
set rs = server.CreateObject ("adodb.recordset")
rs.PageSize = 30
rs.CursorLocation = 3
rs.LockType = 1
rs.CursorType = 3
str = "select * from hwb_son,loginb where hwb_son.userid=loginb.userid"
rs.open str,conn
其中:hwb_son是存储过程生成的一个临时表,直接的存储过程里面获取它的执行结果是总是提示所查询的对象字段不存在,所以就做了一个表先把存储过程执行的结果存到表里,可是用查询分析器查结果是118个记录,但用asp页面查的时候结果只有85个记录,请问只是什么原因,谢谢