Re: Coding superstitions

[buckaduck]

in reply to Coding superstitions

When using DBI, my database connection handle is always named $dbh. This might not seem too superstitious (after all, if my code looks like the example code it should be easier for others to follow), but I confess that I break into a cold sweat at the very thought of using any other variable name.

Then there's my SQL statement handle, $sth. What if I'm writing a program that uses multiple statement handles? I'm sweating already...

buckaduck

[jepri]

My superstition for databases is... don't use multiple statement handles. If I need more than one, I use different $dbh1, $dbh2. Had funny effects form multiple $sth once, don't wanna repeat. It was probably my fault somewhere, though.

____________________
Jeremy
I didn't believe in evil until I dated it.