FINALLY SOLVED!
For anyone having problems with your Apple Official Composite Cable, and perhaps this would include the Apple Official Component Cable. After months of frustration over my $50 dollar cable purchase to display iPad video and photos on my TV through the RCA video input port, the problem has been solved.
I stopped last night at the Apple Store and explained:
I bought the Apple Official Composite cable. I plugged it, and it did not displayed any video, while it would play the Audio channels. I have another iPad, and the result was the same. I tried playing my videos from my iPod Touch and iPod Classic, and to my surprise, the video came through the TV. I didn't know what to make of it.
A Genius from the Genius bar, took my iPad and cable, he connected it to their TV, and ... no video, he was puzzled as well. So he said, let's try another Apple Official Composite Cable, and there it was, video came through the TV.
I am satisfied with the result. That's what I wanted out of my cable purchase, to display video from my iPad to the TV.
I would recommend that if you have same issues I had, go to an Apple Store or contact somebody to the Apple Online Store and explain that a new cable my be the solution.
Thank you.
p.s. I am happy with the problem being solved, however I am a little disappointed that it took this long to realize that it was a defective cable. Apple should acknowledge this problem in their documentation.