SherryG
asked on
Syntax for a regular_expression validation
I need to validate a text field with a regular_expression. I want to ensure that a user enters a time in the format HH:MM AM or HH:MM PM.
I thought I had the syntax correct...but it is not working correctly.
<cfinput type="text" validate="regular_expressi
Any suggestions?
I thought I had the syntax correct...but it is not working correctly.
<cfinput type="text" validate="regular_expressi
Any suggestions?
ASKER
That partially works.
If I enter 1:00 I get the error indicating that I need to use the correct format, in which case I change it to 1:00 PM and it works fine.
If I enter 11:00 it goes directly into the DB without an error. I need the user to be prompted to enter the AM or PM if they forget. For some reason, the code is not catching that error.
Any suggestions.
If I enter 1:00 I get the error indicating that I need to use the correct format, in which case I change it to 1:00 PM and it works fine.
If I enter 11:00 it goes directly into the DB without an error. I need the user to be prompted to enter the AM or PM if they forget. For some reason, the code is not catching that error.
Any suggestions.
ASKER
That partially works.
If I enter 1:00 I get the error indicating that I need to use the correct format, in which case I change it to 1:00 PM and it works fine.
If I enter 11:00 it goes directly into the DB without an error. I need the user to be prompted to enter the AM or PM if they forget. For some reason, the code is not catching that error.
Any suggestions.
If I enter 1:00 I get the error indicating that I need to use the correct format, in which case I change it to 1:00 PM and it works fine.
If I enter 11:00 it goes directly into the DB without an error. I need the user to be prompted to enter the AM or PM if they forget. For some reason, the code is not catching that error.
Any suggestions.
ASKER
That partially works.
If I enter 1:00 I get the error indicating that I need to use the correct format, in which case I change it to 1:00 PM and it works fine.
If I enter 11:00 it goes directly into the DB without an error. I need the user to be prompted to enter the AM or PM if they forget. For some reason, the code is not catching that error.
Any suggestions.
If I enter 1:00 I get the error indicating that I need to use the correct format, in which case I change it to 1:00 PM and it works fine.
If I enter 11:00 it goes directly into the DB without an error. I need the user to be prompted to enter the AM or PM if they forget. For some reason, the code is not catching that error.
Any suggestions.
ignore this if it not an option but why dont you create a little dropdown with AM and PM and add the 12 hours accordingly on the server side...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks HTH. There was a problem on my page. Once I resolved it your code worked perfectly.
Thanks and glad I could help a it.
PS: For future reference, HTH is not my name, it's an acronym and stands for "Hope This Helps" or "Hope That Helps" :)
PS: For future reference, HTH is not my name, it's an acronym and stands for "Hope This Helps" or "Hope That Helps" :)
ASKER
Sorry about that...I just assumed they were your initials!
>> Sorry about that...I just assumed they were your initials!
Your assumption was perfectly normal and I should be the one apologizing for being a lazy typer :)
Your assumption was perfectly normal and I should be the one apologizing for being a lazy typer :)
- ":" doesn't need to be escaped
- "(|)" instead of "[|]"
pattern="[0-9]{1,2}:[0-9]{
Possibly, you'd like to prevent anything else in the expression
pattern="^[0-9]{1,2}:[0-9]
HTH