Thanks, but it is a single key. You rock. > On Jun 7, 2014, at 22:57, Cameron Childress <[email protected]> wrote: > > >> On Jun 7, 2014, at 9:54 PM, Matthew Smith <[email protected]> wrote: >> tablePK = <cfqueryparam >> cfsqltype="cf_sql_varchar" value="#arguments.personKeyList#"> > > If personkeylist is a list of IDs and not a single id, you need to do this > instead > >> tablePK in (<cfqueryparam >> cfsqltype="cf_sql_varchar" value="#arguments.personKeyList#" list="true"/>) > > -Cameron > > ... > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:370798 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
