Here are the trace with version 1.30, this is the same execution but in this version it works.
>-----MENSAGEM ORIGINAL----- >De: "Pedro Anisio" <[EMAIL PROTECTED]> >Enviada em: Seg, 17 Mai 2004 11:22:35 >Assunto: Res: Re: Res: Res: RE: Problems changing from 1.30 to 1.42 > > >>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" >To: "Pedro Anisio" Cc: >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" > > >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:[EMAIL PROTECTED] >> > >>Sent: Friday, May 14, 2004 12:57 PM >> > >>To: [EMAIL PROTECTED] >> > >>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 >> > >> > 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
the_samecode_worked_on_db-1.30.log
Description: Binary data
