in reply to DBI and MySQL issue

Just an idea: may it still be an DB issue, not necessarily an environmental one ?

Is it possible that it is just 'too early' when you're making the SELECT, and that all goes well if you sleep() a while before that ?

Is it during the same session that the INSERT/SELECT sequence happens ?

I suspect that it might be possible that the problem is due to MySQL being late for some reason to let you see the just inserted/updated value.

Hope that helps.

Replies are listed 'Best First'.
Re^2: DBI and MySQL issue
by tbone1 (Monsignor) on May 03, 2007 at 12:45 UTC
    I've been inclining that way. As I said, it is always the same user IDs, 100% repeatable. However, given that I've caught some junk for using Perl to do this, I wanted to get advice from my fellow monks before I start pointing fingers and shouting "J'accuse! at these young punk whippersnappers with their Ruby on Rails and fax machines and hula hoops.

    --
    tbone1, YAPS (Yet Another Perl Schlub)
    And remember, if he succeeds, so what.
    - Chick McGee

[reply]

In Section Seekers of Perl Wisdom