I know i've done this before, but I can't remember now.
Given $id = db_insert('stats_table') ->fields(array( 'created' => 'now()', )) ->execute();
More interested in how to pass functions than in getting it to work.
Le lundi 22 décembre 2014 à 15:36 -0500, Don a écrit :
I know i've done this before, but I can't remember now.
Given $id = db_insert('stats_table') ->fields(array( 'created' => 'now()', )) ->execute();
More interested in how to pass functions than in getting it to work.
I don't know the answer for db_insert(), but for db_select() you would do something like:
db_select('some_table') ->addExpression("RAW SQL STATEMENT");
When you don't really know how, db_query() is your friend.
-- Pierre
Thanks. Looks like db_query() is the only way to go.
-Don-
On 12/22/2014 4:12 PM, Pierre Rineau wrote:
Le lundi 22 décembre 2014 à 15:36 -0500, Don a écrit :
I know i've done this before, but I can't remember now.
Given $id = db_insert('stats_table') ->fields(array( 'created' => 'now()', )) ->execute();
More interested in how to pass functions than in getting it to work.
I don't know the answer for db_insert(), but for db_select() you would do something like:
db_select('some_table') ->addExpression("RAW SQL STATEMENT");
When you don't really know how, db_query() is your friend.
-- Pierre
-
Don -
Pierre Rineau