I have 2 and the flexible cable one from woodcraft is great when bought on sale for $30.---Leonard
http://www.woodcraft.com/Product/2021277/28428/WoodRiver--LED-Shop-Light-with-Magnifying-Glass-Head.aspx
This light has a strong magnetic base and a mount with ac power supply and it will work...