in reply to Re: MySQL syntax error for ON DUPLICATE KEY UPDATE
in thread MySQL syntax error for ON DUPLICATE KEY UPDATE

That was it! Made perfect sense. Thanks!

my $stmt = 'INSERT INTO contact_form (' . join(',', keys %sql) . ') 
            VALUES (' . join(',', ('?') x keys %sql) . ') 
            ON DUPLICATE KEY UPDATE '. join(' = ?, ', keys %sql) . ' =
+ ?';
       
$self->dbh->do( $stmt, undef, (values %sql, values %sql));

[download]
—Brad
"The important work of moving the world forward does not wait to be done by perfect men." George Eliot

Replies are listed 'Best First'.
Re^3: MySQL syntax error for ON DUPLICATE KEY UPDATE
by rhesa (Vicar) on Jul 20, 2008 at 08:12 UTC
    Alternatively, you can refer to the values in the insert part with the values() function: 
    insert into  foo    (bar, baz) 
             values (?,   ?)
on duplicate key update
             bar = values(bar)
           , baz = values(baz)

    [download]
    So your statement string would be: 
    my $stmt = 'INSERT INTO contact_form (' . join(',', keys %sql) . ') 
            VALUES (' . join(',', ('?') x keys %sql) . ') 
            ON DUPLICATE KEY UPDATE '. join(', ', map { "$_ = values($
+_)" } keys %sql);

    [download]
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom