Did a bit more research on compact fluorescents (CF's).
The ESU product does seem to require a double pin fixture rathern than a typical screw-in fixtures. You can sort of see that here:
http://www.esuweb.com/products/602ESU_Reptile_Compact_Fluorescent_Lamps_Reptile_Compact_Fluorescent_Lamps_(Japanese_Square_Pin_Base)_DESERT_7%25_UVB_COMPACT_FLUORESCENT_LAMP_55_WATT_22_INCH.htm
But now it appears that Big Apple has introduced a CF lamp that can be used in a standard incandescent fixture:
http://www.bigappleherp.com/Reptile_Supplies/Product/UVB_Mystic_Fluorescent_Light_Series_262300.html
Also, Zoo Med's CF bulbs screw into normal fixtures:
http://www.reptiledirect.com/index.asp?PageAction=VIEWPROD&ProdID=932
Lastly, The Bean Farm carries a CF that is supposed to produce a lot of UV. It also screws into a normal socket. You can find it at the bottom of this page:
http://www.beanfarm.com/lighting/3.html
None of these bulbs are the spiral-twist or coil-type CF's. However, some of them do screw into a standard socket. So I think my information has been somewhat misleading. For all I now some of the reptile-specific coil-type bulbs may actually produce a decent amount of UV. I don't know.
Still, for tree frogs and nocturnal geckos smaller amounts of UV are probably unecessary and perhaps even slightly dangerous. I still think a regular CF from Walmart, etc. is probably fine for those herps.
-----
Current snakes:
1.1 Gonyosoma oxycephala - (Silver/Yellow)
3.4 Gonyosoma oxycephala - (Green)
2.1 Gonyosoma janseni - (Black)