Pass database function

[ober]

I'm using the PHPActiveRecord ORM and trying to create a basic query and I would have this same problem if I was writing direct SQL.  How do I pass a database function to a query and have it be parsed correctly?

 

$trail = new AuditTrail();
$trail->aid = "TABLESEQ.nextval";
$trail->uname = $usr;
$trail->adatetime = date("n/j/Y h:i:s A");
$trail->acat = $cat;
$trail->aaction = $action;
$trail->contract_id = $contract;
$trail->save(); 

The 'TABLESEQ.nextval' is an Oracle database 'autonumber' type functionality.  I tried doing it with single quotes, double quotes, no quotes.  How do I get it to recognize it as a DB function?

 

The SQL query would look like: "INSERT INTO TABLE (aid, uname, adatetime, acat, aaction, contract_id) VALUES (TABLESEQ.nextval, '$usr', '".date(n/j/Y h:i:s A)."', '$cat', '$action', '$contract')"

 

Any ideas what I'm doing wrong?

[ober]

Nevermind, I'm just going to use the 'dual' table to grab the nextval and then insert that value into the above.