2. PHPRunner General questions
  3. [SOLVED]  leading zeroes dropped in regex validation field
This topic is locked
[SOLVED]

 leading zeroes dropped in regex validation field

 		12/9/2009 2:21:48 AM
PHPRunner General questions
R
 roadyx author

HI,
i have the following regular expression [0-9]{10} . All leading zeroes are dropped. Some account numbers have leading zeroes which is required. Table column is varchar.
please advice.
Thanks!
-Roadyx
J
 		Jane 12/9/2009

Hi,
what settings do you use on the "View as" settings/"Edit as" settings dialogs?
R
 		roadyx author 1/25/2010



Hi,
what settings do you use on the "View as" settings/"Edit as" settings dialogs?


Hi Jane,
View As is not set to anything

Edit As - is set to Validate As: Regular Expression and Regexp is [0-9]{10}
Need help please!
Thank You!
R
 		roadyx author 1/26/2010

BUMP PLEASE - UNANSWERED



Hi Jane,
View As - is not set to anything

Edit As - is set to Validate As: Regular Expression and Regexp is [0-9]{10}
Need help please!
Thank You!


BUMP PLEASE - UNANSWERED
Sergey Kornilov admin 1/26/2010

Please clarify when and how leading zeroes are dropped. Validation doesn't drop anything. It only tests entered values against validation rules.
R
 		roadyx author 2/10/2010



Please clarify when and how leading zeroes are dropped. Validation doesn't drop anything. It only tests entered values against validation rules.


Found the problem. Datatype was INT. Changed to Varchar. HOWEVER, I had to upload all files to make the change.