Re: Good Programming is Better

[FoxtrotUniform]

in reply to Good Programming is Better

Minor nitpick: if you're just preparing a statement, executing it, and throwing the statement handle away, you may be better off just using $dbh->do(...) instead.

And on the subject of your actual point -- I find this sort of "good programming" arises mostly with orthogonal code: each separate chunk of your code does one thing, does it well, does nothing else, and doesn't depend on anything more than it needs to do its job. Writing orthogonal code (modules, subroutines, etc) gives you a good-sized toolbox of code that you can just plug in and use, and (for me, at least) most of these tools come by decomposing a problem into chunks, then generalizing those chunks just a little.

--
:wq

[George_Sherston]

My rationale for using prepare is so I can use placeholders, so I can have arbitrary numbers of columns, and don't have to think about whether I need quotes. But if one can use placeholders with do, that'd be even sweeter.

§ George Sherston

[gav^]

You can use placeholders with do. Just make sure you use undef as the first param.

$dbh->do('insert into blah (?, ?, ?)', undef, $x, $y, $z);