Re: Global dbh and inserts

[sundialsvc4]

I would recommend that things like last_insert_id be used only immediately after a statement that inserted something, and that the pair of statements be wrapped in an SQL transaction with an appropriate isolation level.   This kind of highly-temporal value must not be maintained in any sort of global variable.   If you do that, you will create a “random, un-reproducible, yet very fatal” bug of the very, very worst kind.

[SleepyJay]

Exactly what I was thinking, yes. Thanks guys! Sounds like I'm not insane (about this stuff, at least).

I think I need to understand the Apache::DBI features better.

Thanks