Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » overruling primary validation time fieldtype
overruling primary validation time fieldtype [message #454] Tue, 12 December 2006 07:51 Go to next message
johandewit is currently offline  johandewit
Messages: 25
Registered: May 2006
Location: Belgium
Junior Member

I want to be able to enter a time value > 24 hours.
During insert/update, this will generate an error "Invalid HOURS", because the std.datevalidation.class only allows hours <= 24.

It seems this 'primary validating rule' cannot be skipped/overruled.

What is the best and/or proper way to achieve this, without making any modification to the framework code.

Re: overruling primary validation time fieldtype [message #455 is a reply to message #454] Tue, 12 December 2006 11:05 Go to previous message
AJM is currently offline  AJM
Messages: 2350
Registered: April 2006
Location: Surrey, UK
Senior Member
Unfortunately the TIME data type is currently limited to 00:00:00 to 23:59:59 as I have only ever used it to represent time of day, not elapsed time. As MySQL supports values in the range '-838:59:59' to '838:59:59' I shall put this on my 'to do' list. I'm not sure if PostgreSQL allows such values, and I know Oracle does not have a TIME type at all.

In the mean time you may find it easier to change your data type to NUMERIC instead of TIME, then you can allow for any number of hours.

Previous Topic: Concurrency / freshness of data objects
Next Topic: Tutorial - problem??
Goto Forum:

Current Time: Fri Jun 14 16:01:01 EDT 2024

Total time taken to generate the page: 0.07265 seconds