Announcement

Collapse
No announcement yet.

Error in Date update

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error in Date update

    Hi to All,
    I have a table in an mySQL DB, that has a column Date.
    In my form, in the event "onBeforeUpdate" I have enetered this code:
    Code:
    {user_update_date} = CURDATE();
    But, when I try to update a record, this error is returned:
    Fatal error: Call to indefined function CURDATE();
    Can Someone help me ?
    Thank You
    Gaetano
    Last edited by nicosia; 03-10-2013, 05:44 AM.
    Thank You and Best Regards
    Gaetano

  • #2
    The errormessage is correct, there's no macro or php function CURDATE();
    If you want the current date inserted / updated in the database you can set the default values. If you go to 'edit fields' you get a list of your database fields. At DBField for insert/update you set 'value'. Then a pulldown appears where you can set current date.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      ...If you go to 'edit fields'....
      Thank You. With Your help I have solved.
      Thank You and Best Regards
      Gaetano

      Comment

      Working...
      X