in reply to Multiple Updates with SQL in one connection

If autocommit is not on by default or turned on when you first connect and get your $dbh you will need to commit as in:

$dbh->commit() unless $dbh->{AutoCommit};

my @a=qw(random brilliant braindead); print $a[rand(@a)];

Replies are listed 'Best First'.
Re: Re: Multiple Updates with SQL in one connection
by Anonymous Monk on Jan 24, 2002 at 02:47 UTC
    Thanks! That was what I needed...