ore
interesting problems by now ;-)
M.
> -Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 12:07 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: UPDATE Statement Problem...
>
>
> IT'S ALIVE
--Original Message-
From: NIPP, SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 11:47 AM
To: 'Michael Ragsdale'; '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
OK. Sorry for my being stupid. Everyon
02, 2002 11:15 AM
To: NIPP, SCOTT V (SBCSI); '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
At 12:01 PM 4/2/2002, NIPP, SCOTT V (SBCSI) wrote:
> New problem now. I appear have resolved my earlier problems. The
>final i
dbh->do(qq{UPDATE systems SET $set WHERE 'Name = $name'});
>
> Not sure what is wrong now though. :(
>
> -Original Message-
> From: NIPP, SCOTT V (SBCSI)
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 10:46 AM
> To: '[EMAIL P
On Tue, Apr 02, 2002 at 11:01:41AM -0600, NIPP, SCOTT V (SBCSI) wrote:
> New problem now. I appear have resolved my earlier problems. The
> final issue appears to have been that the SQL statement was interpreting the
> WHERE clause as having multiple arguments. Quoting the where clause se
At 12:01 PM 4/2/2002, NIPP, SCOTT V (SBCSI) wrote:
> New problem now. I appear have resolved my earlier problems. The
>final issue appears to have been that the SQL statement was interpreting the
>WHERE clause as having multiple arguments. Quoting the where clause seems
>to have resolve
il 02, 2002 10:46 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
I actually have that covered, I think. The variable $set actually
expands to something like ip='192.168.0.1' , speed='450' , etc. This
portion
if $set;
$set .= $key . "=\'$$key\'";
}
}
Thanks again.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:40 AM
To: NIPP, SCOTT V (SBCSI)
Subject: RE: UPDATE Statement Problem...
THe problem with the update
SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:28 AM
To: 'Michael Ragsdale'; 'Tielman J de Villiers'
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
A bit more information... Here is the error message from the Perl
scrip
sage-
From: NIPP, SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:20 AM
To: 'Michael Ragsdale'; 'Tielman J de Villiers'
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
Wow!!! This is one awesome mailing list. I r
). Once I get that
part figured out and going, I think I can home in on the problem rather
quickly. Then I will just have to port this portion of code from my laptop
to my Unix platform.
Thanks again for all of the helpful suggestions. Almost everything
you guys have responded with so far
CTED]]
Sent: Tuesday, April 02, 2002 9:40 AM
To: '[EMAIL PROTECTED]'
Subject: UPDATE Statement Problem...
Hey guys. I am still quite new to the database world and
obviously
in need of help. Not sure if I am just stupid, or if there is really
very
little information to be found concern
At 10:50 AM 4/2/2002, NIPP, SCOTT V (SBCSI) wrote:
> I added a COMMIT immediately after the UPDATE, and still have the
>same problem. Below is exactly what I added, with the lines immediately
>before and after.
>
> $dbh->do(q{UPDATE systems SET = $set WHERE Name = $name LIMIT 1}
ielman J de Villiers'
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
I added a COMMIT immediately after the UPDATE, and still have
the
same problem. Below is exactly what I added, with the lines immediately
before and after.
$dbh->do(q{UPDATE sys
EMAIL PROTECTED]'
Subject: UPDATE Statement Problem...
Hey guys. I am still quite new to the database world and obviously
in need of help. Not sure if I am just stupid, or if there is really very
little information to be found concerning UPDATE statements. I am working
on a MySQ
;); #Just added!!!
} else {
-Original Message-
From: Tielman J de Villiers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 9:39 AM
To: NIPP, SCOTT V (SBCSI)
Cc: '[EMAIL PROTECTED]'
Subject: RE: UPDATE Statement Problem...
Check how you connect -- if Autocommit is not o
ct: UPDATE Statement Problem...
Hey guys. I am still quite new to the database world and obviously
in need of help. Not sure if I am just stupid, or if there is really very
little information to be found concerning UPDATE statements. I am working
on a MySQL database with Perl 5.6.0 and the
Hey guys. I am still quite new to the database world and obviously
in need of help. Not sure if I am just stupid, or if there is really very
little information to be found concerning UPDATE statements. I am working
on a MySQL database with Perl 5.6.0 and the latest DBI version. I am do
18 matches
Mail list logo
