On 4/4/06 15:31, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 4:20 PM
To: Jonathan Mangin; Garrett, Philip (MAN-Corporate);
dbi-users@perl.org
Subject: Re: Not exactly a dbi
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED];
dbi-users@perl.org
Sent: Wednesday, April 05, 2006 2:55 AM
Subject: Re: Not exactly a dbi question
On 4/4/06 15:31, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote
On 4/5/06 7:35, Jonathan Mangin [EMAIL PROTECTED] wrote:
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED];
dbi-users@perl.org
Sent: Wednesday, April 05, 2006 2:55 AM
Subject: Re: Not exactly a dbi question
On 4/4
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 2:55 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
On 4/4/06 15:31, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
-Original
On 4/5/06 9:26, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 2:55 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
On 4/4
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 10:41 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
[snip]
Sorry, I've been answering your question while assuming the mysql
driver
On 4/5/06 9:46, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 10:41 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
[snip
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 10:56 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
On 4/5/06 9:46, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote
On 4/5/06 10:04, Garrett, Philip (MAN-Corporate)
[EMAIL PROTECTED] wrote:
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 05, 2006 10:56 AM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
Paul DuBois schreef:
UPDATE tbl_name SET col_name = 0 WHERE col_name = 0;
If you've selected the rows-changed count, $sth-rows() will always
return 0, because the statement doesn't actually change any col_name
value from its current value.
That would be an odd optimization. The update
On 4/5/06 14:07, Jonathan Mangin [EMAIL PROTECTED] wrote:
- Original Message -
From: Dr.Ruud [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Wednesday, April 05, 2006 11:53 AM
Subject: Re: Not exactly a dbi question
Paul DuBois schreef:
UPDATE tbl_name SET col_name = 0 WHERE
-Original Message-
From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 10:37 AM
To: dbi-users@perl.org
Subject: Not exactly a dbi question
Hi all,
I hope someone here can help me.
The DBD::mysql docs seem to say that mysql_affected_rows is still a
-Original Message-
From: Garrett, Philip (MAN-Corporate)
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 10:52 AM
To: dbi-users@perl.org
Subject: RE: Not exactly a dbi question
-Original Message-
From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
Sent: Tuesday
On Tue, 4 Apr 2006, Garrett, Philip (MAN-Corporate) wrote:
-Original Message-
From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
Hi all,
I hope someone here can help me.
The execute() method returns the number of rows affected for DML
(insert/update/delete) statements,
The execute() method returns the number of rows affected for DML
(insert/update/delete) statements, e.g.
my $rows = $sth-execute($sql) || die can't update: .
$sth-errstr;
print Updated $rows rows.\n;
The || die stuff still works even when 0 rows are affected because in
that case, it
-Original Message-
From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 3:14 PM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
The execute() method returns the number of rows affected for DML
(insert
- Original Message -
From: Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Tuesday, April 04, 2006 3:23 PM
Subject: RE: Not exactly a dbi question
-Original Message-
From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006
-Original Message-
From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 3:14 PM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Not exactly a dbi question
The execute() method returns the number of rows affected
- Original Message -
From: Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Tuesday, April 04, 2006 3:52 PM
Subject: RE: Not exactly a dbi question
-Original Message-
From: Jonathan Mangin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April
On 4/4/06 15:06, Jonathan Mangin [EMAIL PROTECTED] wrote:
Autocommit is on. Perhaps you're misunderstanding.
An update is not supposed to happen if the column to be
updated is equal to the data being stuffed into it.
I want $row to reflect that but $row is always 1
even when an update did
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 04, 2006 4:20 PM
To: Jonathan Mangin; Garrett, Philip (MAN-Corporate);
dbi-users@perl.org
Subject: Re: Not exactly a dbi question
On 4/4/06 15:06, Jonathan Mangin [EMAIL PROTECTED] wrote
Ah. Not broke, but poorly-tuned.
Thanks Paul, and Philip for all your help.
--Jon
- Original Message -
From: Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Tuesday, April 04, 2006 4:31 PM
Subject: RE: Not exactly a dbi question
-Original Message
22 matches
Mail list logo