Re: Res: Res: RE: Problems changing from 1.30 to 1.42

From: Pedro Anisio (pedroanisio_at_ibestvip.com.br)
Date: 05/17/04 

To: <dbi-users@perl.org>
Date: Mon, 17 May 2004 11:22:35 -0300

I used trace() but still cannot figure out what is happening, but still dont
work :-(

I'm sending attached the log files and the program.

 ----- Original Message -----
From: "Tim Bunce" <Tim.Bunce@pobox.com>
To: "Pedro Anisio" <pedroanisio@ibestvip.com.br>
Cc: <dbi-users@perl.org>
Sent: Friday, May 14, 2004 4:44 PM
Subject: Re: Res: Res: RE: Problems changing from 1.30 to 1.42

> Use trace()
>
> Tim.
>
> On Fri, May 14, 2004 at 04:05:44PM -0300, Pedro Anisio wrote:
> > Sorry, I didnt send this part of the code
> >
> > @param = (2, 343520291, 1);
> >
> > >-----MENSAGEM ORIGINAL-----
> > >De: "Pedro Anisio" <pedroanisio@ibestvip.com.br>
> > >Enviada em: Sex, 14 Mai 2004 16:02:14
> > >Assunto: Res: Res: RE: Problems changing from 1.30 to 1.42
> > >
> > >
> > >>I dont get any error on $msg but the UPDATE is not executed and the
values on my database dont' change.
> > >
> > >Pedro
> > >
> > >>-----MENSAGEM ORIGINAL-----
> > >>De: "Reidy, Ron"
> > >>Enviada em: Sex, 14 Mai 2004 15:59:25
> > >>Assunto: Res: RE: Problems changing from 1.30 to 1.42
> > >>
> > >>
> > >>>What is your error?
> > >>
> > >>-----------------
> > >>Ron Reidy
> > >>Senior DBA
> > >>Array BioPharma, Inc.
> > >>
> > >>-----Original Message-----
> > >>From: Pedro Anisio [mailto:pedroanisio@ibestvip.com.br]
> > >>Sent: Friday, May 14, 2004 12:57 PM
> > >>To: dbi-users@perl.org
> > >>Subject: Problems changing from 1.30 to 1.42
> > >>
> > >>Guys,
> > >>
> > >> I'm migrating my system from DBI 1.30 to 1.42 but I found onte
little problem, this piece off code used to worked at 1.30 but now it simple
don't do this update, unless I pass the update values directlty on the
$query. What is causing this? Anyone can help-me?
> > >>
> > >>#!/usr/bin/perl
> > >>
> > >>use DBI;
> > >>
> > >>$query = "update mensagem set mens_stat = ? where mens_codigo = ?
and mens_stat = ?";
> > >>#$query = "update mensagem set mens_stat = 2 where mens_codigo =
343520291 and mens_stat = 1"; prepare($query);
> > >>
> > >> if (!$sth->execute(@param))
> > >> {
> > >> $msg = $sth->errstr;
> > >> $msg =~ s/\n|\r/ /g;
> > >> $msg .= "[$query], ".join(",",@param);
> > >> }
> > >>
> > >>print "$msg\n";
> > >>
> > >>$sth->finish;
> > >>$dbh->disconnect;
> > >>
> > >>exit;
> > >>
> > >>Abra?os,
> > >>
> > >>Pedro An?sio
> > >>
> > >>* iBest. Internet gr?tis com qualidade de internet paga.
> > >>
> > >>Clique abaixo para conectar-se ? internet gratuitamente:
> > >>http://discador.ibest.com.br/mail.html
> > >>
> > >>This electronic message transmission is a PRIVATE communication which
contains
> > >>information which may be confidential or privileged. The information
is intended
> > >>to be for the use of the individual or entity named above. If you are
not the
> > >>intended recipient, please be aware that any disclosure, copying,
distribution
> > >>or use of the contents of this information is prohibited. Please
notify the
> > >>sender of the delivery error by replying to this message, or notify
us by
> > >>telephone (877-633-2436, ext. 0), and then delete it from your system.
> > >>
> > >>
> > >
> > >Abra?os,
> > >
> > >Pedro An?sio
> > >
> > >* iBest. Internet gr?tis com qualidade de internet paga.
> > >
> > >Clique abaixo para conectar-se ? internet gratuitamente:
> > >http://discador.ibest.com.br/mail.html
> > >
> >
> > Abra?os,
> >
> > Pedro An?sio
> >
> >
> >
> >
> > * iBest. Internet gr?tis com qualidade de internet paga.
> >
> > Clique abaixo para conectar-se ? internet gratuitamente:
> > http://discador.ibest.com.br/mail.html
> >
>

Relevant Pages

  • Re: DUL blocking [and white-lists]
    ... Res wrote: ... dnswl.org categorizes hosts into four classes of trust: ... we dont need some whitelisting haven for spammers to tell ... It is up to you to decide if your server blocking/grey-listing rules ...
    (comp.mail.sendmail)
  • Re: Ubuntu 1, Fedora 0
    ... In the meantime res, I'm no longer clicking on reply all for any of your ... Fix your server. ... And one should ask WHY you are replying to me, reply to the list, I dont ... xmas where this list was sending only half of everbodies posts was my ...
    (Fedora)
  • Re: GUMBY GRUB
    ... >>Res, sorry about the hastle you have received over this. ... >Ive been on redhat lists for years and years and years, ... >I dont accept the feedback on this list either, ... >without a clue have no access to my desktop, mail servers, or RH's mail ...
    (Fedora)
  • printing output of a command
    ... i am new to cgi. ... Please let me know why I dont get the data printed? ... But when the $cmd is the snmpquerry, I get nothing on the page, though I get the desired outputwhen I run the script in commandline. ... my $res = qx!$cmd!; ...
    (perl.beginners)