Res: Res: RE: Problems changing from 1.30 to 1.42
From: Pedro Anisio (pedroanisio_at_ibestvip.com.br)
Date: 05/14/04
- Next message: Ron Reidy: "RE: RE: Problems changing from 1.30 to 1.42"
- Previous message: Pedro Anisio: "Res: RE: Problems changing from 1.30 to 1.42"
- Next in thread: Tim Bunce: "Re: Res: Res: RE: Problems changing from 1.30 to 1.42"
- Reply: Tim Bunce: "Re: Res: Res: RE: Problems changing from 1.30 to 1.42"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: dbi-users@perl.org Date: Fri, 14 May 2004 16:05:44 -0300('binary' encoding is not supported, stored as-is) 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
- Next message: Ron Reidy: "RE: RE: Problems changing from 1.30 to 1.42"
- Previous message: Pedro Anisio: "Res: RE: Problems changing from 1.30 to 1.42"
- Next in thread: Tim Bunce: "Re: Res: Res: RE: Problems changing from 1.30 to 1.42"
- Reply: Tim Bunce: "Re: Res: Res: RE: Problems changing from 1.30 to 1.42"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
