On Thu, May 25, 2006 at 04:03:39PM -0400, Peter Halliday wrote:
> Tim and Thomas,
>
> Not sure why this is the case, but I noticed that doing an insert with
> an execute via DBD::Multiplex didn't work when using text that
> contained latex for example. But a do with the same did work.
What kind of "didn't work"? An error? If not, could you enable tracing
and try to see what happening that way.
> After much work I found that calling execute with @_ (even though it was
> empty) caused the error. So I added logic to not call it with @_.
So $sth->execute(@_); "didn't work",
but
my @tmp = @_;
$sth->execute(@tmp);
did?
If so, that seems very odd. Can you come up with a small self-contained
test case?
Tim.
> Peter Halliday
> Excelsior Systems
> http://www.excelsiorsystems.net
> (Phone:) 607-936-2172
> (Support:) 607-329-6905
> (Fax:) 607-398-7928
>
> > -----Original Message-----
> > From: Tim Bunce [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, May 11, 2006 7:44 AM
> > To: Peter Halliday
> > Cc: dbi-users@perl.org
> > Subject: Re: Problem with DBI::Multiplex
> >
> > On Tue, May 09, 2006 at 11:07:38AM -0400, Peter Halliday wrote:
> > > I'm trying to load balance reads across two MySQL database that have
> > replication. The reads are working wonderfully. The inserts actually do
> > insert. However, there are some table that use auto increment primary
> > keys. I can't figure out how to actually get those particular keys now.
> >
> > You could patch DBI::Multiplex so the last_insert_id method uses the same
> > dbh as the previous operation.
> >
> > Patches welcome.
> >
> > Tim.
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.394 / Virus Database: 268.7.1/347 - Release Date: 5/24/2006
> >
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.7.1/347 - Release Date: 5/24/2006
>
>
