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:chedders...@gmail.com] 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 <camer...@gmail.com> wrote: > > >> On Jun 7, 2014, at 9:54 PM, Matthew Smith <chedders...@gmail.com> 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
