I had this same problem: Connecting my 2008 Macbook to my Panasonic with a mini-DVI to HDMI adapter gave me a great picture but no sound.
I was expecting this when I bought the adapter. But I was also expecting -- well, hoping -- that the RCA cables would give me sound. They did -- but only if I switched the Input to AV/Component, which, of course, eliminated the picture.
I found a solution in which the person connected cables from her Mac to an RGB/DVI Audio In port on her TV.
My TV has no such port. And I'm guessing yours doesn't either.
Realizing the answer had to come on the TV end, I Googled until I found a service manual for my particular plasma set. The solution couldn't be simpler.
Go to your TV's Menu < Sound < HDMI input < HDMI 1 in (or whichever port you're using to connect your Macbook), then switch it from Digital to Analog.
That's it. I get a great picture and sound.