jsmith
|
| Posted: 05/03/2003, 5:26 AM |
|
I'm having trouble with setting a timestamp field. When the control type is set to TEXT, my date("Y-m-d H:i") command works fine, but the DB Field is not updated probably due to a Type mismatch. When the control type is set to DATE (as it should be), I get a result like "12/31/69 19:00" for today's date and the DB field is still not updated. I have gone into the connection setup and set the MySQL date format. Anybody have any ideas? Is there a way of bypassing the CCS date format routines? BTW, I'm on version 2.0.6.11 of CCS. Thanks for any help.
|
|
|
|
RonB
|
| Posted: 05/03/2003, 6:23 AM |
|
the timestamp generated by mysql looks like 2003050153450 this means you can set the field to date and in properties set db fromat to yyyymmddHHnnss, just type it since it's not a preselectable format.
RonB
|
|
|
|
Jeff S.
|
| Posted: 05/04/2003, 11:43 AM |
|
I have found that if you do not set up your date format first in the Settings and under the connection, any pre-existing forms will not work and you will have to redo them.
Very annoying but not a killer if you do this up front.
Jeff
|
|
|
|
jsmith
|
| Posted: 05/06/2003, 5:42 AM |
|
Thanks for all the help guys. Things are working now. I found out the CCS will not take the date() command in a SetValue() on a timestamp. CC would but not CCS. It seems CCS wants the integer form of time returned by the time() or mktime() commands. Thanks again
|
|
|
|
|
|
