please use WHERE gu_id IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#ValueList(inquery.gu_id)#" list="yes"/>)
thanks, Dave >>> [EMAIL PROTECTED] 01/14/05 4:15 PM >>> That was it! Thank you very much. Kirk -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jim Flannery Sent: Friday, January 14, 2005 11:50 AM To: [email protected] Subject: Re: [CFCDev] Using queries as arguments Friday, January 14, 2005, 12:33:05 PM, one spoke: KB> What would be the best practice to accomplish this? the last line in the query should be WHERE gu_id IN (#QuotedValueList(inquery.gu_id)#) -- Jim Flannery [EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
