Sql query for multiple parameters [message #388471] |
Tue, 24 February 2009 23:55  |
user71408
Messages: 585 Registered: November 2007 Location: NE
|
Senior Member |
|
|
I am having a form in which i have to find results with multiple Branch ID's. Right now i am using select query in which find is with Single Branch ID. I have written a stored procedure for this. But i should not use any kind of stored proc. So Please let me know the solution asap.
The original line is : AND (@BRANCH_ID IS NULL OR EDC.BRANCH_ID = @BRANCH_ID)
But i need to find with multiple Branch ID's ( both integer and also strings ).
Thank you,
Gan
|
|
|
|
|
|
|
|
Re: Sql query for multiple parameters [message #388510 is a reply to message #388505] |
Wed, 25 February 2009 01:16   |
user71408
Messages: 585 Registered: November 2007 Location: NE
|
Senior Member |
|
|
Hi,
Yes exactly my requirement is the same but i am not sure of how many branch values i will get from frond end. I have those values in an array list and i am sending that as a parameter to back end. So in my case i need a dynamic query which can search with "N" multiple values to a single parameter. And also in what way should i pass those parameters from front end ( can i pass them in an array list or shall i have to pass them in a string ?? )
Please let me know.
Regards
|
|
|
|