nuBuilder Forum

Posted: **Mon Apr 15, 2013 8:02 pm**

Hi,

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

$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.

Posted: **Wed Apr 17, 2013 9:32 am**

D630,

Using nuDebug() should help you find the problem.

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

Steven

nuBuilder Forum

"INSERT ... ON DUPLICATE KEY UPDATE" Syntax

"INSERT ... ON DUPLICATE KEY UPDATE" Syntax

Re: "INSERT ... ON DUPLICATE KEY UPDATE" Syntax