Printable View
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.
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 whingeQuote:
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.
p.s.
regarding ur sig DAS HUGE!
I know, I know...but I can't bring myself to change it.Quote:
Originally posted by SkiNLaB
regarding ur sig DAS HUGE!
:(
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!Quote:
Originally posted by SkiNLaB
IIf
doesnt that suck!
what do u think.
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.
:)
/me endeavours to use switch in the near future