Also, here's some other threads on what firearms to use for a given application:
So You Want To Buy A Gun (different article than the one posted above)
Packing Light, Packing Smart: Essentials of Concealed Carry
Hey Freeper Gals what handgun should I look at....
Gun Experts, need recommendations