Just note that using composite or S-video with an adapter like this works fine, but there's a resolution limit and the picture looks fairly crappy compared to DVI (or even VGA). Many modern flat-panels have VGA or HDMI inputs, so if you have these on your TV, better to use them if possible. If it is an older SDTV, just keep in mind that you might only be able to run at a relatively low resolution which might be great for DVDs etc, but maybe not web surfing.
I've tried using composite and s-video before...it doesn't look as nice as on my LCD monitor. I agree that it's good enough for viewing videos and DVDs but not for surfing or doing any other work unless you hook it by via HDMI....i've not tried that yet so, it might differ..