I've already had that experience - and it's done for me and rollercoasters!
On a day out at Alton Towers with my then-office colleagues (all women I was the only man) I was cajoled into riding on 'Air' straight after another similarly fierce ride, the name of which escapes me. During the ride i did actually lose conciousness, which did not feel good at all.
On disembarking from the ride, all my colleagues expressed concern for my well-being - advising that I had turned a fetching shade of green.
At the time I was debating the order of my two most essential activites, to be completed immediately - lie down on the concrete and then throw up, or throw up and then lie down. By an effort of considerable will-power, i avoided the humiliation of either.
However, the residue of that experience, which I knew at the time, was that this would be my ast ever ride on a roler-coaster. What I did not bargain for, was the fact that even the sight of a roller coaster makes me fee nauseous - so I have to avoid looking at one for more than a few seconds.