Nested if statements in Stored Procedure

[MaxDB - Mailing List]

Hello All,
   I am trying like heck to create a stored procedure that looks like the
following.  I know this stored proc is useless but I am trying to get the
concept here.  I would like to execute multiple lines in nested if
statements.
Thank you for your time.  Please Help!


CREATE DBPROC proc_SomeProc(IN bolEnable BOOLEAN,  IN intUserId INT, OUT
intReturnVal INT) AS
    VAR intMaxOrder INT;

            SELECT
                MAX(Order_Prefrence) into :intMaxOrder
            FROM
                DBA.User_Access
            WHERE
                UserID = :intUserId

             IF intMaxOrder IS NULL THEN
                  SET intMaxOrder = 0
                  SET intReturnVal = 1
                        IF bolEnable = TRUE THEN
                                SET intMaxOrder = 0
                        SET intReturnVal = 2
                        ELSE
                                SET intMaxOrder = 0
                        SET intReturnVal = 3
             ELSE
                  SET intMaxOrder = intMaxOrder + 1
                  SET intReturnVal = 4


             SET intReturnVal = 1;


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]