明明已提供内容但程序还是提示没提供.高手看下

liumingyu218 2009-08-24 09:33:13

Msn=SafeRequestForm("Msn",1)
IDCard=HTMLEncode(IDCard)
Address=HTMLEncode(Address)
Zip=HTMLEncode(Zip)
LinkPhone=HTMLEncode(LinkPhone)
RealName=HTMLEncode(RealName)
Email=HTMLEncode(Email)
QQ=HTMLEncode(QQ)
Msn=HTMLEncode(Msn)
LoveState=HTMLEncode(SafeRequestForm("LoveState",1))
Hobby=HTMLEncode(SafeRequestForm("Hobby",2))
About=HTMLEncode(SafeRequestForm("About",2))
Conn.Execute("Execute SP_USER_REG_THREE '"&UserID&"','"&IDCard&"','"&Address&"','"&Zip&"','"&LinkPhone&"','"&RealName&"','"&Email&"','"&QQ&"','"&Msn&"','"&LoveState&"','"&Hobby&"','"&About&"'")



下面是过程:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SP_USER_REG_THREE]
@IN_USERID VARCHAR(50),
@IN_IDCARD VARCHAR(20),
@IN_ADDRESS VARCHAR(120),
@IN_ZIP VARCHAR(10),
@IN_LINKPHONE VARCHAR(30),
@IN_REALNAME VARCHAR(20),
@IN_REGION VARCHAR(10),
@IN_EMAIL VARCHAR(50),
@IN_QQ VARCHAR(10),
@IN_MSN VARCHAR(50),
@IN_LOVESTATE VARCHAR(20),
@IN_HOBBY VARCHAR(200),
@IN_ABOUT VARCHAR(500)
AS
DECLARE @V_RET_CODE INT
SET @V_RET_CODE = -1001000
IF ISNULL(@IN_USERID,'') = ''
RETURN @V_RET_CODE -1
BEGIN TRANSACTION
BEGIN
UPDATE [dbo].[WEBUSER]
SET IDCARD = @IN_IDCARD,
ADDRESS = @IN_ADDRESS,
ZIP = @IN_ZIP,
LINKPHONE = @IN_LINKPHONE,
REALNAME = @IN_REALNAME,
REGION = @IN_REGION,
EMAIL = @IN_EMAIL,
QQ = @IN_QQ,
MSN = @IN_MSN,
LOVESTATE = @IN_LOVESTATE,
HOBBY = @IN_HOBBY,
ABOUT = @IN_ABOUT,
CHARM = CHARM + 10
WHERE USERID = @IN_USERID
END
IF @@ERROR != 0
BEGIN
ROLLBACK TRANSACTION
RETURN -100
END
COMMIT TRANSACTION
RETURN 100


下面是提示错误信息:


错误类型:
Microsoft OLE DB Provider for SQL Server (0x80040E10)
过程或函数 'SP_USER_REG_THREE' 需要参数 '@IN_ABOUT',但未提供该参数。
/user/registerLast.asp, 第 59 行


浏览器类型:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)

网页:
POST 218 ??? /user/registerLast.asp

POST Data:
UserID=ABOUTt&IDCard=213121232&Address=%C4%E3%CB%F9%D4%DA%BB%FA%B9%B9&Zip=13122223333&LinkPhone=021-24242421&RealName=lalan1&Email=81172710@sina.com&QQ=12344444&Msn=b@b.b&LoveState=1&Hobby=sdfsdf&abou . . .
...全文
46 点赞 收藏 4
写回复
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
liumingyu218 2009-08-24
原来这样...粗心了..一直迷着ABOUT.谢啦~!
回复
hookee 2009-08-24
@IN_REGION 没有传入参数
回复
never exists 2009-08-24
IDCard=HTMLEncode(IDCard)。。。
不知道 IDCard ruequest 了没有
回复
贾米森 2009-08-24
没有传入参数
回复
发动态
发帖子
ASP
创建于2007-09-28

2.8w+

社区成员

ASP即Active Server Pages,是Microsoft公司开发的服务器端脚本环境。
申请成为版主
社区公告
暂无公告