Hi all,
sorry if I overlooked a similar post:
I have a page with a form and item containing this email address
dar.blob@flop.ee
On that item I've made a validation of type
regular expression.
I've got my item in
Validation expression 1 P420_EMAIL
and in
Validation expression 2 '^[a-zA-Z0-9\_\.\-]+@[a-zA-Z0-9\_\.\-]+\.[a-zA-Z]{2,4}$'
If I do
select 'dar.blob@flop.ee'
from dual
where regexp_like('dar.blob@flop.ee' , '^[a-zA-Z0-9\_\.\-]+@[a-zA-Z0-9\_\.\-]+\.[a-zA-Z]{2,4}$')
on the DB this returns my email address as expected.
If I submit my form with that same email address I get my error message from my validation.
What's the difference I'm missing between the Apex way and the DB way of validating with this regular expression?
Thanks a lot!
Kind regards,
Diana