VB.NET SP Parameter - Using a Condition Test as the False Part in an IIf

[Les Matthews]

I have two asp:DropDownList items that have different label values, but the
same data values. I would like the parameter for an SP to come from the
value of the first dropdown if it has a value and from the other one if the
first has no value.

I am attempting to modify the SP's parameter value to acheive this by
embedding an IIf as the false part of its parent IIf, such as:

<Parameter Name="@companyCode" Value='<%#
IIf((Request.Form("ddCompanyCode") <> ""), Request.Form("ddCompanyCode"),
IIf(Request.Form("ddCompanyName") <> ""), Request.Form("ddCompanyName"),
Nothing) %>' Type="VarChar" Direction="Input" />

What I want this to do is use the value in ddCompanyCode if there is one;
and if not, then use the value of ddCompanyName if there is one. If neither
has a value, then pass null to the sp.

The code above produces an error reading: "Argument not specified for
parameter 'FalsePart' of 'Public Function IIf(Expression As Boolean,
TruePart As Object, FalsePart As Object) As Object'."

Can I embed an IIf statement as the false part of a parent IIf statement?

[darrel]

> <Parameter Name="@companyCode" Value='<%#

> IIf((Request.Form("ddCompanyCode") <> ""), Request.Form("ddCompanyCode"),
> IIf(Request.Form("ddCompanyName") <> ""), Request.Form("ddCompanyName"),
> Nothing) %>' Type="VarChar" Direction="Input" />
>
> What I want this to do is use the value in ddCompanyCode if there is one;
> and if not, then use the value of ddCompanyName if there is one. If

neither

> has a value, then pass null to the sp.
>
> The code above produces an error reading: "Argument not specified for
> parameter 'FalsePart' of 'Public Function IIf(Expression As Boolean,
> TruePart As Object, FalsePart As Object) As Object'."
>
> Can I embed an IIf statement as the false part of a parent IIf statement?

Could you just check for the property BEFORE passing it into the SP call?

-Darrel

[Les Matthews]

"darrel" <notreal@hotmail.com> wrote in message
news:d3ed71$dm1$1@forums.macromedia.com...

> Could you just check for the property BEFORE passing it into the SP call?

I think I have it working now after adding parentheses around the expression
of the embedded IIf, ie.
<Parameter Name="@companyCode" Value='<%#
IIf((Request.Form("ddCompanyCode") <> ""), Request.Form("ddCompanyCode"),
IIf((Request.Form("ddCompanyName") <> ""), Request.Form("ddCompanyName"),
Nothing)) %>' Type="VarChar" Direction="Input" />

Thanks, Darrel. I may still follow your suggestion if I run into more
problems.