>>I've since gotten this to work the way I intended, but I wanted to update it to allow the user to search on two different fields if need be. How can I make it also look to another variable for the searching like the code below?
>>
>>
cmd = [exec InTransitRN ?']+fdBlNo+[']
>>
>>So basically I want them to be able use the above if they have that number, but also search on this one:
>>
>>
cmd = [exec InTransitRN ?']+fdRefNo+[']
>>
>>Is there a way to combine the two somehow or does it have to be done separately? Would a CASE statement work here? I was thinking of having it check to see which text box had data in it and use the associated code based on that. I don't know if that's a good way to do it though.
>
>I'd just pass both fields as parameters, then modify the stored proc. to determine which query to use.
>
>
>* Assuming variable named fbBINo and fdRefNo contain values from text box (or are empty)
>cmd = [exec InTransitRN ?fdBlNo, ?fdRefNo]
>
>
>The only question would be will the user see both search fields, or just one of them at a time? Depending on the answer, you'll have to change the stored procedure accordingly. I'd just use an IF statement in the T-SQL to do this.
Both the search boxes are visible at all times, it's just to let the user pick whatever criteria they want to search on.
I'll take them out of the CASE statement and try passing them both in at the same time. I'm sure I'll be back with more problems though.