Stored Procedure Help

[MDB]

Hello all, I know this may not be the correct group but was hoping someone
could help anyway. I have a stored procedure that is not returning the
correct information. For some reason it is not returning the correct lane or
reference number and was wondering if someone can take a look and help
figure out why.

Here is the asp.net code:

OleDbCommand cmd = new OleDbCommand ( "Get_CCAuth_Lan e", conn );
cmd.CommandType = CommandType.Sto redProcedure;
OleDbParameter dbLane = cmd.Parameters. Add("@Lane_Nbr" ,OleDbType.Inte ger);
dbLane.Directio n = ParameterDirect ion.ReturnValue ;
OleDbParameter dbRefNbr =
cmd.Parameters. Add("@Last_Refe rence_Nbr",OleD bType.Integer);
dbRefNbr.Direct ion = ParameterDirect ion.ReturnValue ;

dr = cmd.ExecuteRead er ( );
dr.Close();

string sLane = dbLane.Value.To String();
string sRefNbr = dbRefNbr.Value. ToString();

This is returning 0 as lane number when it should be 1 and 1 as sRefNbr
where it should be 555.
Here is the stored procedure:

ALTER Procedure pmmobile.Get_CC Auth_Lane (out @lane_nbr int, out
@Last_Reference _Nbr int)
begin

DECLARE @CurrentTime DateTime;
set @CurrentTime = now(*);

getloop:
WHILE datediff(Second ,@CurrentTime, now(*)) < 30 LOOP
Select FIRST(Lane_Nbr) , Last_Reference_ Nbr
INTO @lane_nbr, @Last_Reference _Nbr
FROM ccauth_lane WHERE status = 'I' or datediff(Minute , last_accessed,
now(*)) >= 2;

IF @lane_nbr IS NOT NULL THEN
UPDATE ccauth_lane SET status = 'A', last_accessed = now(*) where lane_nbr
= @lane_nbr AND (status = 'I' or datediff(Minute , last_accessed, now(*)) >=
2);
IF @@ROWCOUNT = 1 THEN
return;
END IF;
END IF;
END LOOP;
SET @lane_nbr = -99;
SET @Last_Reference _Nbr = -99;
END

[MDB]

Figured it out, thanks for anyone who looked.

Had the Direction set wrong.......
"MDB" <md*@nowhere.co m> wrote in message
news:uJ******** ******@TK2MSFTN GP05.phx.gbl...

Hello all, I know this may not be the correct group but was hoping someone
could help anyway. I have a stored procedure that is not returning the
correct information. For some reason it is not returning the correct lane
or reference number and was wondering if someone can take a look and help
figure out why.

Here is the asp.net code:

OleDbCommand cmd = new OleDbCommand ( "Get_CCAuth_Lan e", conn );
cmd.CommandType = CommandType.Sto redProcedure;
OleDbParameter dbLane = cmd.Parameters. Add("@Lane_Nbr" ,OleDbType.Inte ger);
dbLane.Directio n = ParameterDirect ion.ReturnValue ;
OleDbParameter dbRefNbr =
cmd.Parameters. Add("@Last_Refe rence_Nbr",OleD bType.Integer);
dbRefNbr.Direct ion = ParameterDirect ion.ReturnValue ;

dr = cmd.ExecuteRead er ( );
dr.Close();

string sLane = dbLane.Value.To String();
string sRefNbr = dbRefNbr.Value. ToString();

This is returning 0 as lane number when it should be 1 and 1 as sRefNbr
where it should be 555.
Here is the stored procedure:

ALTER Procedure pmmobile.Get_CC Auth_Lane (out @lane_nbr int, out
@Last_Reference _Nbr int)
begin

DECLARE @CurrentTime DateTime;
set @CurrentTime = now(*);

getloop:
WHILE datediff(Second ,@CurrentTime, now(*)) < 30 LOOP
Select FIRST(Lane_Nbr) , Last_Reference_ Nbr
INTO @lane_nbr, @Last_Reference _Nbr
FROM ccauth_lane WHERE status = 'I' or datediff(Minute , last_accessed,
now(*)) >= 2;

IF @lane_nbr IS NOT NULL THEN
UPDATE ccauth_lane SET status = 'A', last_accessed = now(*) where
lane_nbr = @lane_nbr AND (status = 'I' or datediff(Minute , last_accessed,
now(*)) >= 2);
IF @@ROWCOUNT = 1 THEN
return;
END IF;
END IF;
END LOOP;
SET @lane_nbr = -99;
SET @Last_Reference _Nbr = -99;
END