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

[runrig]

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.

[nafri]

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);
}