DBD::Mysql UPDATE/REPLACE quoti ng of parameters
"eduard W. Lohmann" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Organization | TTY Internet Solutions |
| Message-ID | <[email protected]> |
Hi, I have an issue.
Working on an amd64 machine running debian-testing.
Mysql.pm: $VERSION = '1.2401';
DBD::Mysql.pm: $VERSION = '3.0006';
I have the following
simple code:
use strict;
use warnings;
use DBI;
my $dbh = DBI->connect("DBI:mysql:nvb2", 'root', undef);
$dbh->do(q{ UPDATE `dbfs` SET file='BLA', owner=3, type='text' WHERE
name = ? AND owner = ? }, {}, ('test', 5) );
$dbh->disconnect();
This work just fine, but when I replace the word UPDATE with REPLACE
it starts to quote the second parameter. The error is:
DBD::mysql::db do failed: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'WHERE name = 'test' AND owner = '5'' at line 1 at
t.pl line 7.
Am I missing something or is this a bug?
Thanks in advance,
Eduard
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/[email protected]