$DAL equivalent of INSERT xxx ON DUPLICATE KEY UPDATE yyy

What exactly is the question? What kind of issue you dealing with?

I am trying to code a simple task to either update a record if it exists or insert a new record in a table which has two key fields.
I would normally prepare a long SQL command like:

" INSERT INTO table ( Field_A, Field_B, Field_C) VALUES ( '" . $variable_a ."' ,'" . $variable_b . "' , '". $variable_c . "') {wrap}

ON DUPLICATE KEY UPDATE Field_C = '" . $variable_c . "' "
(Key fields are 'A' and 'B')
This is a right pain to make sure all the various " and ' are exact.
I was wondering (hoping) if the DAL layer had an inbuilt method of add() on DUPLICATE KEY update().

It might look something like:
global $dal;

$tblEvents = $dal->Table("EventsTable");

$tblEvents->Param["event"]="First event";

$tblEvents->Param["public"]="yes";

$tblEvents->Value["cost"]="$10";

$rs = $tblEvents->Add();
if $rs = duplicate

$tblEvents->update();
Where event and public are keys

Also assuming Add() defaults to using Param as Value
I can use a ->FetchbyID before either add() or update() but then on a NULL record result I have to redefine all the Params to Values which is repetative.

I far prefer the DAL method/syntax but it seems difficult to code an equivalent of INSERT xxx ON DUPLICATE KEY UPDATE yyy to take advantage of it.
Thanks

I see what you mean. No, DAL's Add() method doesn't support ON DUPLICATE KEY UPDATE.

You either need to build SQL query manually or do select first and then either Add or Update via DAL.