Matthew, Have you tried changing the cfquery tags to cfoutput and dumping the query itself to see what is actually being generated? You can also take the output and paste it into a SQL window to run it there. Sometimes you'll get better error information that way.
-- Jeff -----Original Message----- From: Matthew Smith [mailto:[email protected]] Sent: Sunday, June 08, 2014 2:48 AM To: cf-community Subject: Re: Here u go 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:370799 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
