nag22
|
| Posted: 11/17/2004, 3:20 PM |
|
I am trying to display two date fields in record. create_dt and update_dt. i have set the data type to date and default value as general date. I am not able to submit the value to the database. plz help me
|
|
|
 |
tonyk
Posts: 163
|
| Posted: 11/17/2004, 8:51 PM |
|
What database are you using?
Are you using the GUI to build your page or are these hand-coded fields?
If using the GUI make sure you have set the date format up in the project data connection dialogs. For MySql the date format for the database is yyyy-mm-dd HH:nn:ss
If using the GUI then the system should generate the code for you automatically.
If hand coding you will probably need to use functions such as ToSQL which are functions of the connection object. Look them up in help and you will find examples.
Hope this helps
|
 |
|
nag22
|
| Posted: 11/18/2004, 9:36 AM |
|
I am using Mysql and the data format is same as you said. Even if using the GUI the date is not getting posted in the database.
|
|
|
|
Tengel
Posts: 49
|
| Posted: 11/18/2004, 9:55 AM |
|
Be sure you set DBformat as yyyy-mm-dd HH:nn:ss in the properties of the field
_________________
---
Tengel |
|
|
|
nag22
|
| Posted: 11/18/2004, 1:03 PM |
|
Thanks tonyx and Tengel. It works now.
|
|
|
|
