用SQL查询分析 说列名“online”无效 网站会员登录不能用

SQL代码如下

Alter Proc usp_Try_GameLogin_Taiwan

@UserID varchar(18),
@InPassword varchar(18),

@SessionID bigint,
@UserIP varchar(15),

@UserUID int = 0,
@LoginType smallint = 1,
@LoginTime datetime = null

AS

SET NOCOUNT ON

DECLARE
@EnPassword varchar(32),
@InEnPassword varchar(32),

@Leave tinyint,
@Status smallint,

@CompanyIP varchar(15),
@TempIP varchar(15)

SET @Status = -1
SET @LoginTime = GETDATE()

SET @CompanyIP = '61.107.81'
SET @UserIP = LTRIm( RTRIm(@UserIP) )

SELECt @UserUID=UserUID,@EnPassword=pw, @Status=Status, @Leave=Leave FROM Users_Master WHERe UserID = @UserID
-- NotExist User OR Leave User
IF( @UserUID = 0 OR @Leave = 1 )
BEGIN
SET @Status = -3
END
ELSE
BEGIN
-- Check Password
IF ( @InPassword <> @EnPassword )
BEGIN
SET @Status = -1
END
END

-- BlockUser Check
IF( (@Status >= 2) AND (@Status <= 6) )
BEGIN
-- Get Block Limit Date AND Replace date text
DECLARE @BlockEndDate datetime
SELECT @BlockEndDate = BlockEndDate FROM Users_Block WHERe UserUID = @UserUID
IF ( @@ROWCOUNT <> 0 )
BEGIN
-- Block Release
IF ( @BlockEndDate <= @LoginTime )
BEGIN
SET @Status = 0
UPDATE Users_Master SET Status = @Status WHERe UserUID = @UserUID
END
END
END

-- Admin IP Check(2006-02-21)

-- Select
SELECT @Status AS Status, @UserUID AS UserUID

--设置登陆状态
UPDATE Users_Master SET Online = 1 WHERe UserUID = @UserUID

-- Log Insert
IF( @Status = 0 OR @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN

EXEC usp_Insert_LoginLog_E @SessionID=@SessionID, @UserUID=@UserUID, @UserIP=@UserIP, @LogType=0,

@LogTime=@LoginTime, @LoginType=@LoginType
END

SET NOCOUNT OFF
GO

网站会员登录出现

“/”应用程序中的服务器错误。 OnLine

说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.IndexOutOfRangeException: OnLine

源错误:

版本信息: Microsoft .NET Framework 版本:2.0.50727.3053; ASP.NET

UPDATE Users_Master SET [Online] = 1 WHERe UserUID = @UserUID

或查明 Users_Master 中有无 online 字段

-- Select SELECT @Status AS Status, @UserUID AS UserUID

--设置登陆状态 UPDATE Users_Master SET Online = 1 WHERe UserUID = @UserUID

你的SELECT 语句无 FORM语句