G
Guest
Don't know if this is a bug or a feature. I have a SQLDatasource that calls
a stored procedure with 2 parameters. The default values are -1 and ''.
When I set a breakpoint in the 'Selecting' event. The 2nd parameter values
shows as Nothing. Which I'm fine with. But if I don't actually set a value
here and let the code run the select returns no rows.
Not sure what's going on here. I've tried running the stored procedure
through SQL Server Mgmt Studio with different combinations of parameters and
everything work correctly. Anyone with an idea of what is going on?
Thanks.
a stored procedure with 2 parameters. The default values are -1 and ''.
When I set a breakpoint in the 'Selecting' event. The 2nd parameter values
shows as Nothing. Which I'm fine with. But if I don't actually set a value
here and let the code run the select returns no rows.
Not sure what's going on here. I've tried running the stored procedure
through SQL Server Mgmt Studio with different combinations of parameters and
everything work correctly. Anyone with an idea of what is going on?
Thanks.