I will definitely look into that as one of my options it seems more straight forward. my main issue is that the client already had some developer create this system and i have to convince then this is the better way as well...sometimes like talking to a wall...lol
>>>this is what i have so far. > >A probably better idea, if you can modify the table, would be to have >two fields in the table, ie: >- objectiveNo >- parentObjective >Then your list 1.0, 1.1, 1.2, 1.3, 2.0, 2.1, 2.2, 2.3, would be >represented by >objectiveNo parentObjective > 0 1 > 1 1 > 2 1 > 3 1 > 0 2 > 1 2 > 2 2 > 3 2 >Then grouping and summing objectives by parent No would be a breeze in SQL. > > >-- >_______________________________________ >REUSE CODE! Use custom tags; >See http://www.contentbox.com/claude/customtags/tagstore.cfm >(Please send any spam to this address: [EMAIL PROTECTED]) >Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
