Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Debug
Closed tickets.
[FIXED] Wrong JS regex for date-time field
  • Page:
  • 1

TOPIC:

[FIXED] Wrong JS regex for date-time field 10 Aug 2012 02:59 #3083

Hi,

First of all I must thank you for providing such a great tool... for so cheap! It's my first project in J-Cook but I am very exited about all the possibilites your application offers (and all the time I will save)!

What I would like to know is how to configure a table date-time field to be required, with default value 0000-00-00 00:00:00 . The "Preview and test" from field parameters says "Incorrect value" with the following configuration:
Required: yes
Default value: 0000-00-00 00:00:00
Prefil form: no

Date format: inherit, inherit  OR  yyyy-mm-dd HH:MM:SS
Unix format: yes OR no

Preview and test: 0000-00-00 00:00:00


Thanks in advance,

:silly: Sebastien

Please Log in or Create an account to join the conversation.

Last edit: by admin.

Re: Default value for date-time field 10 Aug 2012 03:16 #3084

schartier wrote: Hi,

First of all I must thank you for providing such a great tool... for so cheap! It's my first project in J-Cook but I am very exited about all the possibilites your application offers (and all the time I will save)!

What I would like to know is how to configure a table date-time field to be required, with default value 0000-00-00 00:00:00 . The "Preview and test" from field parameters says "Incorrect value" with the following configuration:

Required: yes
Default value: 0000-00-00 00:00:00
Prefil form: no

Date format: inherit, inherit  OR  yyyy-mm-dd HH:MM:SS
Unix format: yes OR no

Preview and test: 0000-00-00 00:00:00


Thanks in advance,

:silly: Sebastien


After reflexion, I guess it will work anyway. I know that 0000-00-00 00:00:00 is not a good date in php so the value won't be good when entered. But on the db side it should work.

Please confirm, Sébastien.

Please Log in or Create an account to join the conversation.

Re: Default value for date-time field 10 Aug 2012 18:07 #3092

  • VeCrea
  • VeCrea's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Absolute JCook fan
  • Posts: 473
  • Thank you received: 100
Don't know about the time format, but if you want to have a default value in the field, you should check the Prefill form box

Please Log in or Create an account to join the conversation.

Re: Default value for date-time field -validation? 21 Aug 2012 09:58 #3226

HI There
It seems i am experiencing similar issue

If i set the date format for the my_date_time field type to yyyy-mm-dd and HH:MM

if i enter in the validator tester the following

Date Format => yyyy-mm-dd and HH:MM value => 2012-12-12 10:00 = Incorrect Value
Date Format => yyyy-mm-dd and HH:MM value => 2012-12-12 = Pass

Also it appears that the validator tester for time field type is not working on my end
- type in any value regardless of setting -> not getting pass or fail

Thanks in advance

Please Log in or Create an account to join the conversation.

Re: Default value for date-time field -validation? 21 Aug 2012 10:26 #3229

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
I have just changed something now.

Can you give a new try ?

CHANGED :
in dom : html.form.input
means (dom/html/form/input.php)


EDIT
\s in Javascript is treated as unicode
\d isn't, which means only ASCII digits (0-9) are accepted.
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.

Last edit: by admin.

Re: Default value for date-time field -validation? 21 Aug 2012 12:17 #3231

Thanks Admin,
Have refreshed cache, and rebuilt project
sorry to report still same result - validation test fails in the properties box of builder with the following

Date Format => yyyy-mm-dd and HH:MM value => 2012-12-12 10:00 = Incorrect Value
Date Format => yyyy-mm-dd and HH:MM value => 2012-12-12 = Pass

Date Format => yyyy-mm-dd and HH:MM:SS value => 2012-12-12 10:00:00 = Incorrect Value
Date Format => yyyy-mm-dd and HH:MM value => 2012-12-12 = Pass

Date Format => inherit and inherit value => 2012-12-12 10:00 = Incorrect Value
Date Format => inherit and inherit value => 2012-12-12 10:00:00 = Incorrect Value
Date Format => inherit and inherit value => 2012-12-12 = Incorrect Value

Please Log in or Create an account to join the conversation.

Re: Default value for date-time field -validation? 21 Aug 2012 12:28 #3232

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
Can you dump the regex of the first case ?
(Generated JS regex. Check the source of the page)

Did your regex contain \d or \s ?
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.

Re: Default value for date-time field -validation? 21 Aug 2012 12:47 #3233

Sorry Admin
- I was working in the builder properties box
- I can confirm that it is now working in sandbox layout

But...
The same issue persists in the builder properties box - the above fails when entered in to the Preview and test input

Please Log in or Create an account to join the conversation.

Last edit: by BTB300.

Re: Default value for date-time field -validation? 21 Aug 2012 13:35 #3235

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
Ok.

Fixed now also in the builder.
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.

Re: Default value for date-time field -validation? 21 Aug 2012 15:28 #3237

Thankyou
- Can confirm working in builder as well after closing builder and clearing cache and reopening builder

Please Log in or Create an account to join the conversation.

Last edit: by BTB300.
  • Page:
  • 1
Forum
Debug
Closed tickets.
[FIXED] Wrong JS regex for date-time field
Time to create page: 0.107 seconds
“
”

  I found "cook" two days ago. Played around with it for a day and then within a day got rid of two legacy applications in IBM Lotus Domino Notes and replaced them with "cook". It was really easy. A piece of cake. Actually it was even easier than cooking. Cooking involves more work than developing with "cook". What can I say about "cook"? Great application great price for what it delivers great forum with a lot of information and fast responses active and friendly community fast forward moving development cycle So what should I say "Monsieur Le Cook"? Keep the good work going it will lead to success. Having become a paying member in the words of Edith Piaf may I say ..... non rien de rien ... je ne regrette rien. Vive La France.
FK (JED)
         

Get Started

Log In Sign In