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"; <---- This way works @param = (2, 343520291, 1); $sth = $dbh->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.
