in reply to Re: Re: Perl DBI, multiple values question
in thread Perl DBI, multiple values question

The easiest way is to do this is probably :-
my $dbh=DBI->connect(.....); my $query = "INSERT INTO subjects VALUES (?)"; my $sth=dbh->prepare($query); foreach my $subject (split /\0/,$form{'subject'}) { $rv = $sth->execute($subject); } $sth->finish(); $dbh->disconnect();
Hope this helps
UnderMine

Replies are listed 'Best First'.
Re: Re: Re: Re: Perl DBI, multiple values question
by rdfield (Priest) on Nov 22, 2002 at 16:14 UTC
    ...remembering to check the return values for the database calls...

    rdfield