Actually, I think the BIG question is why do you have two queries? At a
minimum you could do something like:
<cfquery name="names" datasource="#DSN#" username="#dbusername#"
password="#dbpassword#">
SELECT REC_ID,CHILD_ID,FIRSTNAME
FROM Children
where REC_ID IN (SELECT Child FROM CFX_Family_Members
WHERE Family = <cfqueryparam value="#URL.ID#"
cfsqltype="CF_SQL_INTEGER">)
</cfquery>
Unless you do need those other fields, in which case a JOIN may be in order.
--- Ben
-----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:262494
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
