have an effect in是说对某些领域有影响或起作用,如in science
have an effect on是对某人某物有影响,如the effect on metal