Nope, I know that one! But the one I’m trying to remember is somewhat like that.
I’m thinking of The End of a a Rainbow by Earl Grant, but the words are in the title and I’m sure you already know the song.