fly_mo
Posts: 109
|
| Posted: 11/07/2006, 6:54 AM |
|
Hello All,
Trying to follow the Add Hidden field to form to a grid. The default is CurrentDateTime/DBFormat yyyy-mm-dd/HH:mm:ss, the mysql table has a datetime field / notnull.
When I submit the result is
0000-00-01 00:00:00
Anyone had a similar problem?
One field either in the grid or table is not happy - been trying variations for about 2 hours and going round in circles!
Regards
John
_________________
John |
 |
 |
WKempees
|
| Posted: 11/07/2006, 7:08 AM |
|
Search this Forum for Hidden Fields Submit.
And you will find that Hidden fields, non-visible Panels and fields are not
Posted, therefore upon submit you do not have a value present.
This is default browser behaviour, but a 'fix' or rather enhancement has
been offered by CCS in version 3.1.
Walter
"fly_mo" <fly_mo@forum.codecharge> schreef in bericht
news:245509e24bfc2a@news.codecharge.com...
> Hello All,
> Trying to follow the Add Hidden field to form to a grid. The default is
> CurrentDateTime/DBFormat yyyy-mm-dd/HH:mm:ss, the mysql table has a
> datetime
> field / notnull.
> When I submit the result is
> 0000-00-01 00:00:00
>
> Anyone had a similar problem?
> One field either in the grid or table is not happy - been trying
> variations for
> about 2 hours and going round in circles!
> Regards
> John
> _________________
> John
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
 |
fly_mo
Posts: 109
|
| Posted: 11/07/2006, 10:42 AM |
|
Hi Walter,
I had an inspiration to delete the mysql field and redo - I had set the field incorrectly...darn...
I had set the values by using DLookups for each
Working well now tho'
John
_________________
John |
 |
 |
|