I'll second this statement. If there's confusion about anything, it's this. Apple has never said that the

TV only works with HD TV's. What they have said, though it's not entirely true, is that the

TV only works with
widescreen TV's. It's right there on
TV spec page:
"Compatible with enhanced-definition or high-definition widescreen TVs capable of 1080p/1080i 60/50Hz, 720p 60/50Hz, 576p 50Hz (PAL format), or 480p 60Hz"
There
are widescreen TV's that are ED (480p), but not HD (720p or higher), and there are 4:3 (standard ratio) that are ED-capable and have a widescreen mode, and the

TV will work with them (though reports are that in widescreen mode it doesn't look very good). Even if the TV is ED-capable but doesn't have a widescreen mode you can still connect the

TV, but the image will be formatted for widescreen and will appear distorted.
To the OP: I think you should follow the previous advice about using the remote to cycle through the resolution settings. I also suspect that your

TV is trying to output a resolution that is too high for the TV you're connecting it to. Like others have said, I strongly doubt that the problem is your cables -- they're the simplest thing in the equation, and least likely not to work. I think your problem is just a setting somewhere.