Actually he can
select menuId, label, foundOn
from dbo.menu
where CAST(menuId AS VarChar(10)) IN (
select foundOn
from dbo.menu
where menuId=#form.selTopLevel2#)
order by menuId
Again, it's a messy messy solution and linking tables are called for.
That said, given what he's got to work with....
Hatton
On Wed, Feb 20, 2008 at 3:56 PM, Rick Root <[EMAIL PROTECTED]> wrote:
> Definately can't use the IN clause for this. That's not what it does.
>
> If you insist on not changing your data structure you could try
> something like this.
>
> where ','+foundOn+',' LIKE '%,#value#,%'
>
> But.. dear god, I'm going to be struck by lightning for even suggesting that!
>
> FORGIVE ME SQL GODS!!!!
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:299519
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
