Re^4: error ..ON DUPLICATE KEY UPDATE value='''

What values should be inserted? If a blank feature_id is valid, supply a NULL (no quotes). If it is not valid, then skip that record.

Comment on Re^4: error ..ON DUPLICATE KEY UPDATE value='''

Replies are listed 'Best First'.
Re^5: error ..ON DUPLICATE KEY UPDATE value=''' by nafri (Initiate) on Aug 03, 2013 at 13:35 UTC
thanks all of you.. i finally sorted it out.. i changed the function to this and it works `if($prodid && $cat_featureid && $value){ my $sql = "INSERT INTO products_features (product_id, feature_id, +value) VALUES (".$prodid.", ".$cat_featureid.", ".$dbh->quote($value) +.") ON DUPLICATE KEY UPDATE value=".$dbh->quote($value); $dbh->do($sql); }` [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re^5: error ..ON DUPLICATE KEY UPDATE value='''
by nafri (Initiate) on Aug 03, 2013 at 13:35 UTC

if($prodid && $cat_featureid && $value){
    my $sql = "INSERT INTO products_features (product_id, feature_id, 
+value) 
        VALUES (".$prodid.", ".$cat_featureid.", ".$dbh->quote($value)
+.") 
        ON DUPLICATE KEY UPDATE value=".$dbh->quote($value);
    
    $dbh->do($sql);
}
[download]

[reply]
[d/l]