Passing Multiple Paremeters from string to integer using IN clause
Posted on 2012-03-23
I have a query "SELECT NAME FROM TABLE WHERE PKEY IN(@PKEY)". Seems simple enough, but @PKEY is my problem. I always get the "unable to convert type varchar to int" message. I've tried numerous different ways from arrays to arraylist. What I'm currently trying to pass resembles: '1,5,9'
I should mention that the data source is for a Telerik report. Some things I've tried:
Me.dataSource.Parameters("@CHECKS").Value ='" & key & "') (where key would be: '1,5,9'
Any help would be greatly appreciated.