On Oct 7, 2011, at 7:25 AM, tiger peng wrote: > Some time, even committed, the data was still mysteriously disappearing while > another tool worked perfectly. > > Why?? >
ROFL. A while back, while I was making changes to a production system, I modified the authentication scripts so that when I logged in all my changes went to test tables, not the production tables. (after all, I'm not the worlds most interesting man <http://memegenerator.net/instance/10264631>) This was a system that I didn't use for real a whole lot. A couple months later I go to use the system for real...and it doesn't work...I spent a half-day trying to figure out why it worked for other people, and not me...:-) I suspect we've all committed more than our share of Stupid Programmer Tricks. > > I was playing on different databases! > >> I know it sounds silly but did you forget to commit? I've been >> doing DB programming for years but every now and again I waste 10-15 >> minutes on mysteriously disappearing data because I forgot to commit. -- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs