Ahh RJ.... I'm sorry to read this. I hope you find the courage and strength to try again. And soon. I'm sure your kicking yourself enough for this so I'm not going to add to your guilt.
The best thing you can do is realise that these situations are going to keep happening in your life if you don't stop drinking. I know you don't want that - you were doing really amazing and you can get to that place again. I believe in you. You've got to believe in yourself though. You can do this.