BINGO !
That's it !
Thank you very much
Rob Bloodgood wrote:
>>I got the same error when the ; is replaced by a space.
>>I know the ; is to be avoid for one statement (that work fine) but how
>>to separate 2 clauses in the same statement ?
>>
>
> You don't. That's what transactions are for. Turn off AutoCommit for your
> statement handle, run two seperate INSERT's, and then call an explicit
> commit:
>
> my $dbh = DBI->connect( blah );
>
> my $first_insert = $dbh->prepare("INSERT x into y");
> my $second_insert = $dbh->prepare("INSERT foo into bar");
>
> {
> local $dbh->{AutoCommit} = 0;
>
> $first_insert->execute();
> $second_insert->execute();
>
> $dbh->commit;
> }
>
> HTH!
>
> L8r,
> Rob
>
> #!/usr/bin/perl -w
> use Disclaimer qw/:standard/;
>
>
>
>
>
--
**************************************************
Eddie IANNUCCELLI
Tel: 05 61 28 54 44 - Fax: 05 61 28 53 08
INRA, Laboratoire de G�n�tique Cellulaire
Chemin de Borde Rouge - Auzeville -BP27
31326 Castanet Tolosan
**************************************************
