Hello all ..
If I am using a MySQL table type that supports transactions (InnoDB),
will the DBI calls support transactions as well (the DBD specification
for MySQL says it does not support transactions, but I dont think they
had InnoDB tables in mind).
I have a tidbit that I wonder if anyone else can verify.
I have a select statement that happens in an object.
$self->{STR} = $self->{DBH}->prepare("statement ...")
or warn "This is a warning"
$self->{STR}->execute()
or warn "This is a warning"
$array_ref = $self->{STR}->fetchr
Hello all...
I have a DBI call that returns a long list of names (10,000). I am
using fetchall_arrayref. The call seems to take up 40MB of memory. Is
this normal? Am I doing something wrong? Is there any special way to
free up this memory.
If I cannot connect, take a time out
if ($DBI::err != 0) {sleep(20);}
else
{$success = 1;}
$try++;
}
Will this work. Or should I put the connection attempt in an EVAL
statement and check for $@ after the statement execut
te to file ./i0_samt_trans/i0_int_sender.frm
(Errcode: 2)
There seems to be no rhyme or reason for this. Sometimes the table
will get created without a problem, and sometimes it will not.
Any ideas?
--
Brad Phinney
Senior Technical Consultant, Sendmail Inc.
E-Mail : [EMAIL PROTECTED]
Phone