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!!

Please provide more details on the steps to reproduce.

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

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,

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

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.