Did 4 camera shoot in a night club (Sony PD-150/170s) and the stage lighting was solid red. All the stage lighting was red, no white light, no other lights.

Club refused to change the bad lighting. I tried having someone on stage hold a white card for white balance but the results looked still looked red. While we can work on color correction in post (shift to blue/cyan), would there have been any way to fix on site through white balance. I would have thought white balancing on a card with the red light spilling on it would shift the red towards white.

You can use cards of a different color to shift/tint the image: see this post for some good examples (http://www.dvinfo.net/conf/showthread.php?t=50403) but you won't be able to retrieve colors that aren't in image in the first place. In your example, you would have just been faking out the camcorder into thinking the "red" was another color.

You may be able to fix some of your image with the color correction tools in your NLE.

I probably would have needed a Blue or Cyan card. Gosh I'd need the entire spectrum based on what I've seen in some clubs. This was the worst I'd seen in a couple of years.

I did see some digital still photogs and the LCD pix didn't look bad. They must have been auto white ballancing on something but, believe me, I saw no white items up there and short of our attempt with a white card, there was no white at all on the stage.