Sorry Mike, Joshua is absolutly correct. Dont listen to my nonses ;)
What I did was trying to use something like this which to my knowledge
doesnt work on MySQL servers.
$dbh->commit();
$dbh->rollback();
/Jonas
> ----- Original Message -----
> From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 31, 2004 9:02 AM
> Subject: Re: Transaction Not supported
>
>
> On Tuesday 30 March 2004 09:35 pm, Jonas Lindén said something like:
> > I dont think that transactions are supported (yet?) by the PERL DBI.
>
> to "Mike Blezien" <[EMAIL PROTECTED]>. My response follows.
>
> Yes they are...at least I have used them in a project before using
> Perl::DBI.
>
> [EMAIL PROTECTED] ~]$ perl
> use DBI;
>
> print $DBI::VERSION, "\n";
> 1.37
>
> [EMAIL PROTECTED] ~]$
>
>
> My mysql.pm shows $VERSION = '2.0419'
>
> Are you sure you are connecting to an InnoDB database and that you are
doing
> transactions on InnoDB tables?
>
> My code is rather simple:
>
> #Begins the transaction
> $dbh->do('BEGIN');
> .
> .
> .
> .
> $dbh->do('COMMIT');
>
> What does your code look like?
>
> j----- k-----
>
> --
> Joshua J. Kugler
> Fairbanks, Alaska
> Computer Consultant--Systems Designer
> .--- --- ... .... ..- .- -.- ..- --. .-.. . .-.
> [EMAIL PROTECTED]
> ICQ#:13706295
> Every knee shall bow, and every tongue confess, in heaven, on earth, and
> under
> the earth, that Jesus Christ is LORD -- Count on it!
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
