Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: IF in WHERE

  1. #1
    New to the CF scene
    Join Date
    Sep 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IF in WHERE

    i did something like this :

    SELECT bla
    FROM bla
    WHERE bla AND
    ... more bla ... AND

    IF(1<2, 'M_TAB.ID=3','M_TAB.ID=4')

    ORDER BY otherbla


    ...but it seems that M_TAB.ID=whatever aint really working. I just whant to decide which other WHERE clause i take.
    Can´t bee that difficult, right?



    ___
    stellarid

  • #2
    New to the CF scene
    Join Date
    Sep 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    ...got it

    IF(1<2,M_TAB.ID=$ID,1)

    ...thanks4helping...


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •