高手请看一看，这个存储过程为什么出错？

sxsgssgs 2003-12-12 03:51:06

<%
Set objCmd = Server.CreateObject("ADODB.Command")
objCmd.CommandText="sp_Check"　　　　 '存储的过程名
objCmd.CommandType=adCmdStoredProc　　 '将 CommandText 作为存储过程名进行计算
Set objCmd.ActiveConnection = Conn

Set tmpFirstParam=objCmd.CreateParameter ("UserName",adVarChar,adParamIntput,30)

objCmd.Parameters.Append tmpFirstParam

Set tmpSecondParam=objCmd.CreateParameter ("UserPwd",adVarChar,adParamInput,30)

objCmd.ParaMeters.Append tmpSecondParam

Set tmpThirdParam=objCmd.CreateParameter ("RetValue",adChar,adParamOutput,8)

objCmd.Parameters.Append tmpThirdParam

objCmd("UserName")=Request.FORM("UserName")

objCmd("UserPwd")=Request.FORM("UserPwd")

objCmd.Execute
%>

The Check Result is <%=objCmd("RetValue")%>

<%

Conn.Close

%>

<HTML><HEAD><TITLE>Registration Page</TITLE>
<LINK href="include/FONT.CSS" type=text/css rel=stylesheet>
<META content="Microsoft FrontPage 5.0" name=GENERATOR><meta http-equiv="Content-Type" content="text/html; charset=gb2312"></HEAD>
<BODY text=#000000 bottomMargin=0 vLink=#000000 aLink=#000000 link=#000000 bgColor=#FFFFFF leftMargin=0 topMargin=0 rightMargin=0 marginheight="0" marginwidth="0">
<table width="776" height="69" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="320"> </td>
<td width="185"> </td>
<td width="271"> </td>
</tr>
<tr>
<td> </td>
<td>请输入用户名与密码</td>
<td> </td>
</tr>
</table>

<table width="400" height="82" border="0" align="center" cellpadding="0" cellspacing="0">
<form name="form1" method="post" action="">
<tr>
<td width="76">用户名：</td>
<td width="324"><input name="username" type="text" id="username"></td>
</tr>
<tr>
<td>密码：</td>
<td><input name="userpwd" type="password" id="userpwd"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="确定"></td>
</tr>
</form>
</table>
</body>
</html>

...全文

36 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

troopers 2003-12-17

打赏
举报

我也是刚接触到存储过程。我想问
UserPwd
UserName
都没在存储过程里定义。能拿来用嘛？

sxsgssgs 2003-12-12

打赏
举报

CREATE PROCEDURE sp_Check
@CHKName varchar(30),@CHKPass varchar(30),
@ISValid char output
AS

if exists(select UserName from Users
where UserName=@CHKName and UserPwd=@CHKPass)
begin
select @ISValid="pass"
end
else

select @ISValid="Invalid"
GO
这个是存储过程

mfkiqpl 2003-12-12

打赏
举报

大哥。你太强了。你的东西我看不懂。。

sxsgssgs 2003-12-12

打赏
举报

谢谢呀

sxsgssgs 2003-12-12

打赏
举报

Microsoft VBScript 编译器错误错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft VBScript 编译器错误错误 '800a0408'

无效字符

/sqlweb/chkuser.asp，行5

objCmd.CommandText="sp_Check"　　　　 '存储的过程名
-------------------^