Just bought Smashbox Studio Skin foundation and I love it. It stays on all day - most foundations disappear from my nose after about 4 hours. Very buildable also so you can really sheer it out for day wear.
Other long wearing ones I like are Teint Idole by Lancome and Cover FX Power Play - they don't budge much on me.
Double Wear great but can be a bit cakey. I have the Double Wear Water/Nude also. It can be a bit glowy - but it lasts longer than other glowy ones.
Cover FX Power Play is probably the best I've tried for lasting in warm climates.