Hi all,
I just found the error. The error was I did not include the execute statement
in my perl script.
Thank you very much for whom reply my email. Thank you very much. I really
appreciate it.
Eko Budiharto <[EMAIL PROTECTED]> wrote:
Date: Sun, 20 Mar 2005 07:04:27 -0800 (PST)
From: Eko Budiharto <[EMAIL PROTECTED]>
Subject: update command
To: ActivePerl@listserv.ActiveState.com, mysql@lists.mysql.com,
[EMAIL PROTECTED]
Hi,
I am having problem with update command. I run it directy in the mysql console,
it works. But when I run it from perl, it does not work.
here is the perl script
my $server2 = 'localhost';
my $db2 = '';
my $username2 = '';
my $password2 = '
my $dbh2 = DBI->connect("dbi:mysql:$db2:$server2", $username2, $password2);
my $query = "UPDATE flightInfo SET route='chicago, atlanta' WHERE
passengerIndex='15' AND passengerName='Eko Budiharto';";
$dbh2->disconnect;
I do not why the "UPDATE" command does not work with the script. Please help. I
thought I used wrong syntax.
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
