The singer enjoyed a 1965 hit with “Baby the Rain Must Fall,” the title song of a Steve McQueen movie but was hardly a one-hit wonder