"INSERT ... ON DUPLICATE KEY UPDATE" Syntax

[D630]

Hi,

In "After Save" i run this code to modify a another table :

Code: Select all

$sql  = "INSERT INTO verbindung (";
$sql .= "formal_Erschliessung_ID)";
$sql .= "VALUES (";
$sql .= "'$recordID')";
nuRunQuery($sql); 

This works fine. Now i would like to change it into a "INSERT ... ON DUPLICATE KEY UPDATE" Syntax, but i can not get at it. Can anybody give me a helping hand?

Thanks.

[admin]

D630,

Using nuDebug() should help you find the problem.

http://wiki.nubuilder.com/tiki-index.ph ... g_pString_

Steven