Hi
You can use Exception Handling. the execute statement can be
placed between eval operater
ex::
$sql = "INSERT INTO TABLE VALUES(?,?)";
$db->prepare($sql);
foreach $ctr(0..$#arr){
eval{
$db->execute($ctr,$arr[$ctr]); #if is
successfull execute
};
if($@){
next: ##ignore it
}
}
Regards
satya
"Ho, Tony" wrote:
> Hi guys,
> I am writing a Perl program that utilises DBI to perform SQL select
> statements to extract information from the database and write them to a
> file.
>
> If the database goes down during the process of executing of the SELECT
> statements and writing to the file, what happens ?
>
> Does anything get written to the file ? The filehandle will probably be
> lost, right ?
>
> I would be most grateful if you could help me.
> Thanks in advance.
> Tony
>
> Tony Ho
> Lucent Technologies
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>
>
