IN operator usage in stored procedure
Posted on 2006-07-12
I'm developing a simple form which will show some records, user can select more than one record at a time.
Now my query is to how to give all the selected records (say PK's) in the query which is put up in a stored procedure.
select * from user u where u.Pk in (1,2,3,4)
user will select 1,2,3,4 from front end but how to pass these pk's to the query.
I've tried by giving array but i was not able to.
Please give solution for above or suggest any other way of doing this.