I guess I had implicitly assumed only one row would match.
You could fix it by testing for RecordCount NEQ 0 in each loop and
incrementing a list.
But the inefficiencies illustrate the inherent inefficiency of storing a
list in a column if you want to query the column as you intend.
As others have noted, depending on how much time this takes with your data,
you might want to consider normalizing.
best, paul
At 09:15 AM 12/12/00 -0500, you wrote:
>Yea, that's not effecient. That could potentially generate 12 - 14 queries
>in the loop.
>
> >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
