It's a string cf_sql_string
Sandra Clark ============================== http://www.shayna.com Training in Cascading Style Sheets and Accessibility -----Original Message----- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Friday, December 01, 2006 2:34 PM To: CF-Talk Subject: Cfqueryparam and a list 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:262490 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
