Support Any way to change sound notifications for different apps?

view story

http://androidforums.com – When mail arrives, my phone alerts me with the Android whistle. When CNN alerts are pushed to my screen....same whistle. I want to change that. There is no option in the CNN app to change notification sound. Is there an app or setting that allows you to assign specific alert sounds to apps that push notifications? Thank You (General)