grum
Posts: 42
|
| Posted: 08/05/2007, 6:10 PM |
|
I have upgraded to codecharge 2 to 3. I have some custom updates and inserts that used to work in the old version. I have a table that has a col called - Timestamp. I want to have a custom update that inserts the date-timestamp when the row is either added or updated.
It has converted the custome update to : -
Field Name:Timestamp
FieldType:Text
Formal:blank
Parameter Name:"NOW()"
Parameter Type:Expression
This gives the error:-
Database Error: Incorrect datetime value: 'NOW()' for column 'Update_Timestamp' at row 1
|
 |
 |
grum
Posts: 42
|
| Posted: 08/05/2007, 6:27 PM |
|
Sorry - I have found what my problem is with the expression.
Thanks
Ian
|
|
|
|
|
