Then she met Mr. Coleman , known for compositions like '' Hey , Look Me Over , '' '' If My Friends Could See Me Now '' and '' The Best Is Yet to Come , '' at a party in San Miguel de Allende , Mexico , and married him on Oct. 1 , 1997 , next to Niagara Falls .