A majority of Americans are against the war, according to a new poll. This has implications for the mid-term elections in November.