Dynamics of cosmological scalar fields revisited