Right well it's good you realised that was a stupid opener. If you would have approached me with this line I would not have been impressed - more embarrassed.
I have been in this position before. When I go into a club, my guard is UP. I've witnessed my fair share of drunked losers, indeed one man kept photographing me on his phone all the time, even though I told him to his face to stop it.
Sometimes it would be best if you had approached these girls with one of your friends - it then makes it a nice group and adds to the conversation. If you are focused on getting the number of one of the girls, it might make the other one feel left out, or akward.
Don't let it get you down - you just need to understand why women act this way and try and work around it.