I've only had 2 one night stands that really were just 1 night without leading to any relationship, but I would sometimes get over attached to women even if I'd just gone out with them once without sex, that was probably why in my early days it never went any further or I ended up just "friends" when I was the one who wanted more.
My first one night stand was when I was quite young, I got very drunk (well the girl was actually buying me drinks lol) and I ended up in bed at a hotel when I was on holiday (the hotel owner made me pay extra the next day lol), the problem was when I woke up she wasn't anywhere near as nice looking as I remembered when I was very drunk (to say the least) and I thought, "NO, I didn't" lol, it was really awkward and she chased me for a while since she'd already taken my details and she happened to live not far from where I lived. I wasn't interested and I felt guilty about the whole thing even though she was the one that chased me from the start, I kept fobbing her off hoping she would get the message over the phone, then she finally got nasty with me asking me why I'd apparently led her on, we had a row and that was the end of it (a relief).
I was a bit older on my 2nd 1 night stand, I was truly interested in another woman (someone definitely not good for me who I later ended up with in a very destructive relationship), but I was feeling really p**s*d off as I thought I'd got no further with her after just cuddling her for a night before she went home with no further contact for ages. I however had a lot more confidence than normal at the time and felt like I needed cheering up so I asked a neighbour out which ended in a one night stand. My neighbour was very good looking and at the time I didn't really know whether the relationship would go further or not, but afterwards I heard from the woman I really wanted which made me loose complete interest in her. My neighbour did call a couple of times afterwards, but I had other interests. BTW I had a lot more confidence and I actually felt invincible at the time entirely due to an antidepressant which has now been banned in many countries with numerous law suits called
Paroxetine (AKA Seroxat), while on this harmful drug I was a different person and not in a good way, that's just one reason why I condemn antidepressants these days as so called "quick fixes".