Great it works,
But what does undef do?
-Original Message-
From: Rhesa Rozendaal [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 5:34 AM
To: Viswanatha Rao
Cc: [EMAIL PROTECTED]
Subject: Re: perl mysql table row update
Viswanatha Rao wrote:
> I run an update on a row w
Viswanatha Rao wrote:
I run an update on a row with following code:
my $id = '100';
my $nodeid = "localhost";
my $nodeid_in = $dbh->quote($nodeid);
If you're going to use placeholders, then you don't need to dbh->quote.
print ("Updating a NODEID=$nodeid_in with SLA ID $id \n");
my $sth = $dbh->do("
; <[EMAIL PROTECTED]>
Sent: Friday, July 30, 2004 2:23 PM
Subject: RE: perl mysql table row update
> I run an update on a row with following code:
>
> my $id = '100';
> my $nodeid = "localhost";
> my $nodeid_in = $dbh->quote($nodeid);
>
>
I run an update on a row with following code:
my $id = '100';
my $nodeid = "localhost";
my $nodeid_in = $dbh->quote($nodeid);
print ("Updating a NODEID=$nodeid_in with SLA ID $id \n");
my $sth = $dbh->do("update TableSLA set NodeID=? where ID= $id",