We just did a survey just like this for AT&T (a client of ours) and I've done this survey in a few other markets, and it's always the same:

55-65% DSL
35-40% Cable
5% and less dialup.

For what it's worth, I'm posting this via a Treo 650, which is configured as a dialup networking "modem" connected wirelessly via Bluetooth to a Macbook Pro. I also have used the Verizon wireless broadband card recently and ordered one of my own today. That's a 770K connection that works in most metro areas and while mobile.

In a connectivity survey we did for another company, we also found that FIOS - the fiber-to-the-home service is growing astonishingly fast. Finally, we're seeing a slow, but steady, increase in the use of metro Wi-Fi. It's still down in the range of statistical noise, but it's starting to show signs of real growth.