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

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 . . .

...全文