I don't believe this will work.
At 01:32 PM 12/12/00 +0000, you wrote:
>SELECT A.A_xRef, B.B_xRef
>FROM Table_a A, Table_b B
>WHERE B.B_xRef LIKE '%' + A.A_xRef + '%'
You could instead do a query to get a list of all the A_xRef
and then do a CFLOOP over them with
<CFLOOP QUERY="MyQuery"
<CFQUERY blah..
SELECT B.B_xRef
FROM Table_b B
WHERE B.B_xRef LIKE '%#MyQuery.A_xRef#%'
</CFQUERY>
</CFLOOP>
As the original poster of the above noted it's obviously not that efficient.
best, paul
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
