Hey guys -
I made a floor lamp like this over the weekend, and this thread was helpful in getting me going.
I used a 3/4" "dresser coupling" from Home Depot to attach the bottle to the pipe. It's basically a compression fitting with two sides, worked great. For the light fixture, I used a candelabra socket on threaded tube to position it inside the bottle, and a small candelabra bulb. 15w is way too dim, ordered a 40w halogen from Amazon that's on the way.
I set up the valve as an electrical switch according to this instructable, worked great:
http://
http://m.instructables.com/id/Water-Valve-Light-Switch-for-a-Pipe-Lamp/
Really appreciate the thread you put together, I joined the forum to post this

.
Best,
Chris