On 2/20/08, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: > 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....
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. Let's say foundOn has three values in three rows: "1,5,10" "2,6,7" and "3,4,8,9" ... "1" will never be "in" that set of values. Rick -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:299556 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4