close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Date Formats, Validations

Thread began 3/11/2014 12:42 pm by asarcona308398 | Last modified 3/12/2014 3:21 pm by Jason Byrnes | 721 views | 5 replies |

asarcona308398

Date Formats, Validations

Just a note here... when using WA Databridge dataassist page insert wizard form validations the script does NOT accommodate for CAPITAL output is :

"\b(1[0-2]|0[1-9]):[0-5]\d\s[ap]m\b/i"

using: am or pm passes.. AM or PM fails

using the "all" included formats passes AM or PM:

".*"

maybe a future update will have a correction or independent choices. I don't know if this is a bug or just something I've been able to re-produce in my environment.

I also have seen problems with applying both a required and a formatting validation... only one is applied to the page!!

Sign in to reply to this post

Jason ByrnesWebAssist

Please provide more details on the steps to reproduce.

Sign in to reply to this post

asarcona308398

if you use a database column with values such as: 10:45 PM , 11:00 AM etc and the column values are used to populate the values on the select list the validation will fail for all but the "all formats" option in the date/time validations choices

if you need to see a page let me know

Tony

Sign in to reply to this post

Jason ByrnesWebAssist

My question what are the steps you use in the data Assist wizard to reproduce the problem.

you're example of the expression:
"\b(1[0-2]|0[1-9]):[0-5]\d\s[ap]m\b/i"

is out of context. I need to know what settings you are using to generate the page s and where you are seeing the expression in your example in order to be able to log a comprehensive bug,

Sign in to reply to this post

asarcona308398

Hey Jason,

What I mean to say is:
"\b(1[0-2]|0[1-9]):[0-5]\d\s[ap]m\b/i" fails on Server Validation

while:

".*" passes Server Vailidation


the form generated by WADA insert wizard produces:

$WAFV_Errors .= WAValidateDT((isset($_POST["recital_start_time"])?$_POST["recital_start_time"]:"") . "",false,".*","","",true,"","","",true,4);
$WAFV_Errors .= WAValidateDT((isset($_POST["recital_finish_time"])?$_POST["recital_finish_time"]:"") . "",false,".*","","",true,"","","",true,5);

which PASSES Validation
if choosing: 02:38 PM (hh:mm tt) in the wizard, under the Time format type, validation fails
I would like to limit the form input to: 02:38 PM (hh:mm tt) format.




AFTER adjusting the Server Behavior in the generated page to: hh:mm tt

$WAFV_Errors .= WAValidateDT((isset($_POST["recital_start_time"])?$_POST["recital_start_time"]:"") . "",false,".*","","",true,"\b(1[0-2]|0[1-9]):[0-5]\d\s[ap]m\b/i","","",true,4);
$WAFV_Errors .= WAValidateDT((isset($_POST["recital_finish_time"])?$_POST["recital_finish_time"]:"") . "",false,".*","","",true,"\b(1[0-2]|0[1-9]):[0-5]\d\s[ap]m\b/i","","",true,5);

also, even if the wizard produces the above the validation will fail...
this is validating against a select list, database generated data in the form of "12:30 PM" one selection accepted, no multiple
the list is populating a valid choice and value when explored with firebug

I hope that helps
Tony

Sign in to reply to this post

Jason ByrnesWebAssist

Thank you for the clarification, it was not clear that this was in Server Validation.

I have added a feature request to our system to have an option for upper case added.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...