> That wouldn't work though, because menuId is going to be a single
> number.. even if casted to a string. foundOn is a string containing a
> comma separated list of values.
You're right. I even went to the length of creating a table on my db
server to prove I was right and I was wrong.
Understand, I had to name my table testing and the join is U G L Y but
here's how I got the results erik's looking for:
select DISTINCT t1.menuId, t1.label, t1.foundOn
from testing t1 inner join testing t2 ON
t2.foundon LIKE '%,' + CAST(t1.menuId AS VarChar(10)) + ',%' OR
t2.foundon LIKE CAST(t1.menuId AS VarChar(10)) + ',%' OR
t2.foundon LIKE '%,' + CAST(t1.menuId AS VarChar(10)) OR
t2.foundon = CAST(t1.menuId AS VarChar(10))
where t2.menuid = 6
order by t1.menuId
You would need to replace "testing" with "menu" and the 6 with your
<cfqueryparam>
Hatton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299557
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
