Tatong Steele
|
| Posted: 08/15/2002, 6:09 AM |
|
Help.....
i'm having a problem in getting the current date to show the as default activation_date in a new record and passing this to mysql.
The newly created record shows the current date (date_activation) but,
The new database record always shows 1/1/0001 as the current date in the recordset (date_activation) .
On the "date_activation_BeforeShow()" I encoded this "$flddate_activation = date("YYYY-mmmm-dd");"
But all for nothing. Do you Guys have any idea whats should I do?
Thanks,
tatong steele
|
|
|
 |
Nicole
|
| Posted: 08/15/2002, 6:43 AM |
|
Hello,
please install latest version CCS1.0.7 from http://www.codecharge.com/download/files/CCStudio1_0.exe
You do not need to assign the default value in the before show event. Just select CurrentDate from Default value field property.
|
|
|
|
Tatong Steele
|
| Posted: 08/15/2002, 9:46 AM |
|
I upgraded and follow what was suggested but still the date that always reflect in the mysql database is 1/1/0001
Is there a custom code out there to solve this?
Thanks ,
tatong steele
|
|
|
|
Nicole
|
| Posted: 08/16/2002, 1:31 AM |
|
Hello,
Please keep in mind for MySQL+PHP, that you should specify the following
"Date format" property in Connection/Server tab:
yyyy-mm-dd HH:nn:ss
This format is required because type of datefields is timestamp,
this info is required for timestamps to work properly.
Moreover on the forms you should select different DBFormat on the form for different type fields. Once form is created please check following settings on Data tab:
DataType: Date
Format (display format): select one you like
DBFormat: should match db date format. Select one from dropdown list or type it manually (in case there's no desired format in drop down ).
Note, that on record form you should enter dates in displaying format, then it will be converted to selected db format before inserting to db.
|
|
|
|
Tatong Steele
|
| Posted: 08/19/2002, 11:22 AM |
|
Thank you very much :)
Everything is working fine now... i didnt know about the dbformat at the bottom of properties could fix that.
I appreciate it a lot.
Thank you again!
tatong steele
|
|
|
|
|
