Hi

Help with this problem would be appreciated.

I have a stored procedure with default NULL parameters which should allow all
items to be listed if All on the drop down list is chosen.

The problem is that if All is chosen no records are returned.

I think i have traced the problem back to the parameter value within the MM
stored procedure code that never sends a NULL value into the stored procedure.

<Parameter Name="@*******" Value='<%# IIf((Request.QueryString("*******") <>
Nothing), Request.QueryString("*******"), "NULL") %>' Type="VarChar"
Direction="Input" />

I have tried the following code which works when i test the stored procedure
within Dreamweaver but it throws an error when i test the page.

IIf((Request.QueryString("*******") <> Nothing),
Request.QueryString("*******") IS System.DbNull.Value )


Am i doing something stupid?

Regards
J