View Single Post
  #3 (permalink)  
Old October 1st, 2004, 11:03 PM
mcinar mcinar is offline
Friend of Wrox
Join Date: Jun 2003
Location: , NY, USA.
Posts: 141
Thanks: 1
Thanked 0 Times in 0 Posts

Thank you for reply.
What I need to try is to also pass "actual column id" with the value. In this case, "State_ID" is my column name and the value is "1".
The reason that I need this type of logic is to be able to pass multiple columns with their values based on the filtering conditions.

For Example;

In Visual Basic:

I have "State" and "Industry" options for user to choose. Let's say a user picks "State" but not "Industry". In this case my string variable
"strWhere" will be "State_ID = 10" Let's say #10
corresponds to "NY" from the pick list.
The advantage of having this type of logic prevents the "if" logic in the "Stored Procedure".

Thank you.

Reply With Quote