On 12/07/11 08:32, ZhangJun wrote:
my $dbh = DBI->connect();
my $sth1 = $dbh->prepare( $sql_a );
my $sth2 = $dbh->prepare( $sql_b );
$sth1->execute;
$sth2->execute;
while ( my ($id) = $sth1->fetchrow_array ) {
$sth2->execute( $id )
}
# is it possible ?
Sometimes. Depends on which DBD you are using and then sometimes it depends on
which driver you are using under that DBD.
You'll need to tell us which DBD (and possibly driver) you are using.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
