CF, SQL Stored Proc

[Tangorre, Michael]

What is the best way to pass a list of strings into a stored proc for
use with an IN operator.


For example...


variables['strBusinessRecipientList'] = "mike,time,john,chuck,joe";


<cfprocparam
     cfsqltype="CF_SQL_VARCHAR"
     value="#variables['strBusinessRecipientList']#"
     null="No">


Inside the stored proc I have...


SELECT
    ....
FROM
    ....
WHERE
    ID IN (@BUSINESS_RECIPIENT_LIST)


Obviously this errors out since SQL will attempt to convert
"mike,time,john,chuck,joe" to integer values given that the individual
values within the list are not in quotes. Is it easiest to just build a
list to pass in in the proper format?.. i.e. 'mike','john', etc...


Thanks,


Mike

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---