1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How use null syntax with IF statment

Discussion in 'Oracle Development General' started by relaxsurya, Mar 30, 2012.

  1. relaxsurya

    relaxsurya Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    How use null syntax with IF statment

    For Ex: <?xdofx:if (x='' or x=0 ) then 'good' else 'error' end if?>
    But the above statement shows an error -cannot convert to number


    cud you help me solve this issue,

    Regards,Surya
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Surya,

    why dont we try like " X is not null " as of your requirement?
     
  3. ac.arijit

    ac.arijit Forum Advisor

    Messages:
    217
    Likes Received:
    22
    Trophy Points:
    280
    Location:
    Kolkata, India
    Hi Surya,

    I hope u're looking for something like this.

    To define behavior when the element is present and the value is not null:
    To define behavior when the element is present, but is null:
    To define behavior when the element is not present:
    *[desired behavior] --> Designer's intended action
     
  4. crazyclementiam

    crazyclementiam Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    hi relaxsurya,
    please try to fix like this <?xdofx:if (x!='' or x!=0 ) then 'error' else 'good' end if?>
    Clement crazy
    connected commerce