That cable is intended for only certain cards, and I've never seen one that uses an adapter like that for TV out. Maybe some laptops? It might be physically possible to make this work in software (DAC on a video card is fast enough), but I'm unaware of any solutions for it. You could probably at least get B&W, but I doubt that's what you want.
Should probably look in to either the adapter Ken posted a link to (J-Rok also has one, but it's more than double the price last I checked) or a scan converter, depending on your needs.