Results 1 to 7 of 7

Thread: Iif

  1. Dec 2nd, 2002, 10:34 PM #1
    SkiNLaB
    SkiNLaB is offline

    Thread Starter
    Fanatic Member SkiNLaB's Avatar
    Join Date
    Jan 2002
    Location
    Sydney, Australia
    Posts
    747

    Iif

    IIf(Booking Is Nothing, "Null", Booking.BookingID)

    Booking is an object

    and i wish to put its BOOKING id in sql string i am building

    and this IIF looked to do the job quite nicely in a compact and neat way.

    but nooo it HAS to evaluate booking.bookingid regardless it booking is nothing or not! (resulting in an error if it is nothing)

    doesnt that suck!

    what do u think.
    Reply With Quote Reply With Quote
  2. Dec 2nd, 2002, 10:49 PM #2
    crptcblade
    crptcblade is offline
    The Devil crptcblade's Avatar
    Join Date
    Aug 2000
    Location
    Quetzalshacatenango
    Posts
    9,091
    Yeah, well, that's the nature of subs/functions. All expressions are evaluated before being passed into the procedure. You'll find the same issue with any function.
    Laugh, and the world laughs with you. Cry, and you just water down your vodka.


    Take credit, not responsibility
    Reply With Quote Reply With Quote
  3. Dec 2nd, 2002, 11:02 PM #3
    SkiNLaB
    SkiNLaB is offline

    Thread Starter
    Fanatic Member SkiNLaB's Avatar
    Join Date
    Jan 2002
    Location
    Sydney, Australia
    Posts
    747
    Originally posted by crptcblade
    Yeah, well, that's the nature of subs/functions. All expressions are evaluated before being passed into the procedure. You'll find the same issue with any function.
    yeah but i just wanted to whinge

    p.s.

    regarding ur sig DAS HUGE!
    Reply With Quote Reply With Quote
  4. Dec 2nd, 2002, 11:07 PM #4
    crptcblade
    crptcblade is offline
    The Devil crptcblade's Avatar
    Join Date
    Aug 2000
    Location
    Quetzalshacatenango
    Posts
    9,091
    Originally posted by SkiNLaB
    regarding ur sig DAS HUGE!
    I know, I know...but I can't bring myself to change it.

    Laugh, and the world laughs with you. Cry, and you just water down your vodka.


    Take credit, not responsibility
    Reply With Quote Reply With Quote
  6. Dec 2nd, 2002, 11:11 PM #5
    Armbruster
    Armbruster is offline
    Fanatic Member Armbruster's Avatar
    Join Date
    Sep 2002
    Location
    Maryland Heights, MO
    Posts
    857

    Re: Iif

    Originally posted by SkiNLaB
    IIf

    doesnt that suck!

    what do u think.
    Yes! I finally found a use for Ilf in one of my programs this past week. It worked out great but even Microsoft warns of its use in MSDN. You definatly have to be careful because of how it evalutes both expressions it is testing!
    "Look! Up in the sky! It's a bird! It's a plane! It's Diaper-Head Boy! (there by my name!) Yes, Diaper-Head Boy, who disguised as my son, Seth, fights a never-ending battle for truth, justice and terrorizing my house!

    Resistance is futile, you will be compiled . . . Please!
    Reply With Quote Reply With Quote
  7. Dec 2nd, 2002, 11:13 PM #6
    crptcblade
    crptcblade is offline
    The Devil crptcblade's Avatar
    Join Date
    Aug 2000
    Location
    Quetzalshacatenango
    Posts
    9,091
    You think IIf is bad, start using Switch, where you have a a whole lot of params you can pass in and screw up on.

    Laugh, and the world laughs with you. Cry, and you just water down your vodka.


    Take credit, not responsibility
    Reply With Quote Reply With Quote
  8. Dec 3rd, 2002, 12:49 AM #7
    SkiNLaB
    SkiNLaB is offline

    Thread Starter
    Fanatic Member SkiNLaB's Avatar
    Join Date
    Jan 2002
    Location
    Sydney, Australia
    Posts
    747
    /me endeavours to use switch in the near future
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width