【求助】ASP数据库返回值获取问题~各位大哥大姐大叔大婶大伯大妈都进来帮帮忙啊。

[Xu_Jia_Wei]

存储过程
CREATE PROCEDURE slcEmployeeEnrollmentNewBySSN
@employee_ssn int
AS

SELECT Count(Tbl_login.ssn) AS CountOfssn
FROM Tbl_login INNER JOIN (Tbl_employee_enrollmentNew INNER JOIN
EmployeeCoverageEnrollment ON
Tbl_employee_enrollmentNew.Employee_SSN =
EmployeeCoverageEnrollment.employee_ssn) ON (Tbl_login.gr_number =
Tbl_employee_enrollmentNew.Gr_number) AND (Tbl_login.ssn =
Tbl_employee_enrollmentNew.Employee_SSN)
WHERE (((Tbl_login.gr_number)=2900) AND ((Tbl_login.LoginType)='M')
AND ((Tbl_login.ssn) Between 111110000 And 111119999) AND
((Tbl_employee_enrollmentNew.completed)<>0) AND
((Tbl_employee_enrollmentNew.intApproved)=3) AND
((Tbl_employee_enrollmentNew.blAccept)<>0) AND
((EmployeeCoverageEnrollment.coverageID)=908))
and Tbl_login.ssn=@employee_ssn
GO

是一个登录判断功能,要根据登录用户的值来显示页面的一部分，上面的存储过程如果登录的用户值在范围内，则显示1，不在范围内显示0，，当前的登录用户是页面里的session("ssn")变量，现在要把它赋值给这个存储过程中的@employee_ssn,我现在要在网页里判断，如何读取这个1和0.当1的时候显示下面HTML代码，0则不显示。贴出我写的部分代码:

<%
set conn = server.createobject("adodb.connection")
strCnn = "driver={sql server};server="& temp_database &"; uid=internetguest;pwd=guest;database=" & session("membercalls")
conn.open strcnn
Set Count = Conn.Execute("slcEmployeeEnrollmentNewBySSN" & session("ssn"))
rs.close
if Count="1" then
%>
<Table border="0" cellspacing="0" cellpadding="0" width="100%">
<Tr><Td bgcolor="<% = color1 %>" colspan="2">
<Table border="0" cellspacing="1" cellpadding="2" width="100%">
<Tr><td bgcolor="#33FFCC" >
<b><font size="">HELLO! <a href="https://www.baidu.com/" target="_blank" style="color:#3300FF "><b>click here</b></a> to check detailed information about your benefit.</font></b>
</td></tr>
</Table>
</Table>
<%end if%>


请问哪里有错？应该如何修改。不知道表达的意思是否明白，请高手帮忙下很急~谢谢

[Xu_Jia_Wei]

郁闷，没人帮忙啊

[山的那一边]

菜鸟路过，无能为力

[spurs1007]

set conn = server.createobject("adodb.connection")
strCnn = "driver={sql server};server="& temp_database &"; uid=internetguest;pwd=guest;database=" & session("membercalls")
conn.open strcnn

Count = Conn.Execute("slcEmployeeEnrollmentNewBySSN" & session("ssn"))(0)

if Count="1" then

[Xu_Jia_Wei]

3楼的不对哦，我现在报错
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'slcEmployeeEnrollmentNewBySSN111112900'.

/members/home.asp, line 465

来人救救我啊，解决不了这问题我麻烦就大了。

[gg1060225]

存储过程...不会...

[tx_rain]

没有看你的存储过程。
只看了你的asp代码，你的代码错误

你看看这个吧
http://www.chinaz.com/Program/Asp/1021415222008.html
你调用存储过程本身应用格式就是错的！