iif not working

[rodchar]

hey all,

i'm using an iif and it's not working how I think it should work (go figure).
Anyway,

IIf(IsNothing(Request.QueryString("Sd")), Me.sortDir = "asc",
Request.QueryString("Sd"))

When i run this the expression evaluates as true but the true part doesn't
happen for some reason. It's like it's broke or something.

Does anyone have Bill Gates' home phone number? I really need to ask him
about this one.

thanks,
rodchar

[Marina]

That is because in the True part, you are doing a comparison to a string.
You should expect that will result in True or False.

What are you expecting exactly? Can you please provide complete details on
what you expect to happen and what is happening, as well as the value of all
variables involved.

"rodchar" <ro*****@discussions.microsoft.com> wrote in message
news:A2**********************************@microsof t.com...

hey all,

i'm using an iif and it's not working how I think it should work (go
figure).
Anyway,

IIf(IsNothing(Request.QueryString("Sd")), Me.sortDir = "asc",
Request.QueryString("Sd"))

When i run this the expression evaluates as true but the true part doesn't
happen for some reason. It's like it's broke or something.

Does anyone have Bill Gates' home phone number? I really need to ask him
about this one.

thanks,
rodchar

[rodchar]

i thought i was doing an assignment statement?
"Marina" wrote:

That is because in the True part, you are doing a comparison to a string.
You should expect that will result in True or False.

What are you expecting exactly? Can you please provide complete details on
what you expect to happen and what is happening, as well as the value of all
variables involved.

"rodchar" <ro*****@discussions.microsoft.com> wrote in message
news:A2**********************************@microsof t.com...

hey all,

i'm using an iif and it's not working how I think it should work (go
figure).
Anyway,

IIf(IsNothing(Request.QueryString("Sd")), Me.sortDir = "asc",
Request.QueryString("Sd"))

When i run this the expression evaluates as true but the true part doesn't
happen for some reason. It's like it's broke or something.

Does anyone have Bill Gates' home phone number? I really need to ask him
about this one.

thanks,
rodchar

[Marina]

IIF is a function. You are passing parameters to that function. Whenever
there is a method call, all the arguments are evaluated. Meaning the = sign
will be treated as a comparison operator, not the assignment operator.

Not only that, but all the arguments will be evaluated no matter if the
condition that is the first argument is true or false. This is because IIF
is not a language construct - it is a function. So all arguments will be
evaluated before they are called. This is unlike constructs in C#,
javascript, and other languages where there is an actual language construct
for this that evaluates the true part or false part only if necessary.

"rodchar" <ro*****@discussions.microsoft.com> wrote in message
news:EE**********************************@microsof t.com...

i thought i was doing an assignment statement?
"Marina" wrote:

That is because in the True part, you are doing a comparison to a string.
You should expect that will result in True or False.

What are you expecting exactly? Can you please provide complete details
on
what you expect to happen and what is happening, as well as the value of
all
variables involved.

"rodchar" <ro*****@discussions.microsoft.com> wrote in message
news:A2**********************************@microsof t.com...

> hey all,
>
> i'm using an iif and it's not working how I think it should work (go
> figure).
> Anyway,
>
> IIf(IsNothing(Request.QueryString("Sd")), Me.sortDir = "asc",
> Request.QueryString("Sd"))
>
> When i run this the expression evaluates as true but the true part
> doesn't
> happen for some reason. It's like it's broke or something.
>
> Does anyone have Bill Gates' home phone number? I really need to ask
> him
> about this one.
>
> thanks,
> rodchar

[rodchar]

thank you this helped.

"Marina" wrote:

IIF is a function. You are passing parameters to that function. Whenever
there is a method call, all the arguments are evaluated. Meaning the = sign
will be treated as a comparison operator, not the assignment operator.

Not only that, but all the arguments will be evaluated no matter if the
condition that is the first argument is true or false. This is because IIF
is not a language construct - it is a function. So all arguments will be
evaluated before they are called. This is unlike constructs in C#,
javascript, and other languages where there is an actual language construct
for this that evaluates the true part or false part only if necessary.

"rodchar" <ro*****@discussions.microsoft.com> wrote in message
news:EE**********************************@microsof t.com...

i thought i was doing an assignment statement?
"Marina" wrote:

That is because in the True part, you are doing a comparison to a string.
You should expect that will result in True or False.

What are you expecting exactly? Can you please provide complete details
on
what you expect to happen and what is happening, as well as the value of
all
variables involved.

"rodchar" <ro*****@discussions.microsoft.com> wrote in message
news:A2**********************************@microsof t.com...
> hey all,
>
> i'm using an iif and it's not working how I think it should work (go
> figure).
> Anyway,
>
> IIf(IsNothing(Request.QueryString("Sd")), Me.sortDir = "asc",
> Request.QueryString("Sd"))
>
> When i run this the expression evaluates as true but the true part
> doesn't
> happen for some reason. It's like it's broke or something.
>
> Does anyone have Bill Gates' home phone number? I really need to ask
> him
> about this one.
>
> thanks,
> rodchar