http://www.perlmonks.org?node_id=137127


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

Replies are listed 'Best First'.
Re: Re: Coding superstitions
by jepri (Parson) on Jan 09, 2002 at 10:36 UTC
    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.