Jan K. van Dalen
|
| Posted: 07/29/2008, 8:19 AM |
|
Hi Everyone,
I have a table with a field defined as: `EffecitveTime` time default NULL,
In CCS, I added a TextBox with Data Type of: Date and format: h:nn AM/PM
I'm able to enter the info but is not getting written to the db. Any ideas?
Thanks.
|
|
|
 |
jjrjr1
Posts: 942
|
| Posted: 07/29/2008, 9:29 AM |
|
Hi
Have you set the DBFormat property of the field?
That must be set in order for the data to be put into the database.
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
 |
|
Jan K. van Dalen
|
| Posted: 07/29/2008, 12:16 PM |
|
Hi jjrjr1 ...
1) Yes, by DBFormat is set.
2) Should the a MySQL Time type field be defined as "Date" in CCS with the
correct format?
Thanks for your help.
"jjrjr1" <jjrjr1@forum.codecharge> wrote in message
news:5488f455bc7ff9@news.codecharge.com...
> Hi
>
> Have you set the DBFormat property of the field?
>
> That must be set in order for the data to be put into the database.
>
>
> _________________
> Keep On Truckin' 
> John Real
>
> http://realsites.biz
> http://realtest.biz
> http://therealdealforyou.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
maxhugen
Posts: 272
|
| Posted: 07/31/2008, 5:21 PM |
|
I don't know if this will help, but have you tried formatting the textbox as HH:nn:ss, or just HH:nn?
_________________
Max
www.gardenloco.com | www.eipdna.com | www.chrisarminson.com |
|
|
|
|
