You could do this in a loop:
<cfquery name="qryOne" datasource="" dbtype="ODBC">
SELECT myValueOne
FROM tblOne
</cfquery>
<cfloop query="qryOne">
<cfloop list="#qryOne.myValueOne#" index="i">
<cfquery name="qryTwo" datasource="" dbtype="ODBC">
SELECT myValueTwo
FROM tblTwo
WHERE myValueTwo = #i#
</cfquery>
</cfloop>
</cfloop>
----- Original Message -----
From: "David Clay" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 5:40 PM
Subject: Lists
I have more than 1 value in a table field (values=test1,test2)
How can I query those to match one of those values with a value of another
table?
Thank you fro your help.
Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
303.770.8506
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists