|
| Re: Cascading DropDownLists with 'ALL' and SELECT...CASE problem |
 |
Thu, 20 Mar 2008 22:49:57 +000 |
Aha, ok. Then it would be:
SELECT [a bunch of fields] FROM [WexData] WHERE ([Asset] = @asset AND
@asset<>'All') OR (@asset='All' AND DEPT = @dept)
|
| Post Reply
|
| Re: Cascading DropDownLists with 'ALL' and SELECT...CASE problem |
 |
Thu, 20 Mar 2008 23:02:29 +000 |
I get
No value given for one or more required parameters.
|
| Post Reply
|
| Re: Cascading DropDownLists with 'ALL' and SELECT...CASE problem |
 |
Thu, 20 Mar 2008 23:59:42 +000 |
You need to add @dept to the parameters collection of the datasource control.
Make sure it is added after the first one. They need to be added in the order
they appear in the SQL.
|
| Post Reply
|
| Re: Cascading DropDownLists with 'ALL' and SELECT...CASE problem |
 |
Fri, 21 Mar 2008 15:19:52 +000 |
That appears to work, Thank you very much!
|
| Post Reply
|
|
|
|
|
|
|
|
|
|