> On 2/20/08, erik tom <[EMAIL PROTECTED]> wrote:
> > The query is
> > select menuId,label,foundOn from dbo.menu where menuId IN (select
> foundOn from dbo.menu where menuId=#form.selTopLevel2#) order by
> menuId
>
> So you're expecting "foundOn" to be equal to menuID - if that's the
> case, why is foundOn a text datatype?
>
> You're basically saying this:
>
> select menuId, label, foundOn from dbo.menu where menuId IN ('foo')
>
> What are the possible values of foundOn?
>
> --
> Rick Root
> New Brian Vander Ark Album, songs in the music player and cool behind
> the scenes video at www.myspace.
com/brianvanderark
here the result
11 Programs Programs 0 NULL
12 Reports Reports 0 NULL
8 Lessons Lessons 0 NULL
13 Resources Resources 0 NULL
14 test1 test2 0 NULL
49 test5 test5 8,11,12 NULL
52 test10 test10 8,11 NULL
53 test11 test11 8,11,12,13 NULL
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:299511
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
