WHERE rec_id IN (<cfqueryparam value="#kidlist#" list="yes" cfsqltype="cf_sql_integer" />)
use whatever cfsqltype is appropriate. just use the LIST attribute of the tag (set to "yes"). On 12/1/06, Richard Dillman <[EMAIL PROTECTED]> wrote: > I have a URL value passing to a Cfquery > > <cfquery name="CheckFam" datasource="#DSN#" username="#dbusername#" > password="#dbpassword#"> > SELECT ID, Child, Family > FROM CFX_Family_Members > WHERE (Family = <cfqueryparam value="#URL.ID#" > cfsqltype="CF_SQL_INTEGER">) > </cfquery> > > then dump the ID's to a Valuelist to be used in the next query > > <cfset kidlist = ValueList(CheckFam.Child) /> > > <cfquery name="names" datasource="#DSN#" username="#dbusername#" > password="#dbpassword#"> > SELECT REC_ID,CHILD_ID,FIRSTNAME > FROM Children > where REC_ID IN(#kidlist#) > </cfquery> > > The *BIG* Question is do I need to use a cfqueryparam in the second query, > and IF I do, how would I put the info into it IE what cfsqltype? > > -- > -- > Richard Dillman > [EMAIL PROTECTED] > (317) 916-8341 > > "If you want happiness for an hour -- take a nap. > If you want happiness for a day -- go fishing. > If you want happiness for a month -- get married. > If you want happiness for a year -- inherit a fortune. > If you want happiness for a lifetime -- help someone else." > -- Chinese proverb -- > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262489 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
