Good point Marlon--just be sure and include the separator attribute in there as well: <cfqueryparam cfsqltype="cf_sql_integer" list="yes" separator="," value="#userIdList#" />
I haven't tested this lately (I always include it anyway) but according to the livedocs it's required if you're passing a list. Thanks for bringing that up! Matt On Fri, 5 Nov 2004 15:36:41 -0600, Marlon Moyer <[EMAIL PROTECTED]> wrote: > one of the easiest ways to work with list values is to use the > cfqueryparam keyword list so: > > select from tours where tourtype IN (<cfqueryparam > cfsqltype="cf_sql_integer" list="true" value="#userIdList#">) > > -- > Marlon > ---------------------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
