[97 Boxster]

When you pull the door apart make sure that you wiggle the wires a bit while its connected to your battery still to see where the connection is bad. For me the connection was at the harness and it was loose. When I pulled the harness and connection towards me while reaching in the door my window would drop. When I let the harness go it would go back up. I tried everything and I resorted to a zip tie to hold the harness snug to the door moulding by using one of the holes in the door where the clips go to fasten the interior panel to the door (if that makes sense). It was so easy and has worked for 6 months so far.

Just to clarify, I wrapped the long zip tie around the connected harness/door lock mechanism and then routed the zip tie through a hole in the door frame. The idea was to pull the connection just slightly and keep it from moving around. It gave me a solid connection.

Sorry no photos. Good luck.