7 Replies Latest reply on May 25, 2012 7:15 AM by goodychurro1

    Timestamp in database for new row

    goodychurro1 Level 1

      I have a timestamp field in my db.
      In my mysql program I clicked on the box that says "On Updated Current_Timestamp" which works fine for updating rows in the database and adds the time.
      Now I want it to add the time for NEW rows, so in the default box I put now();  but I get an sql error. I am doing it in the database to lessen the load on coldfusion but maybe something like this is better in my cfquery insert into sql?:


      <cfqueryparam cfsqltype="cf_sql_timestamp" value="#now()#" />


      What do you think I should do? Thanks