2. PHPRunner General questions
  3. Required fields - Not containing just spaces
This topic is locked

Required fields - Not containing just spaces

 		7/24/2012 3:40:04 PM
PHPRunner General questions
C
 copper21 author

Hello all,
Is there a way to mark a field (nvarchar 100 in SQL) as required, but also require characters and just not spaces? I have some people who think they are smart and throw a couple of spaces in a field to satisfy the "required field" requirements. I need them to be able to enter all characters, including spaces, but not just spaces.
Thanks,
Brian
P
 		procheck 7/25/2012

I don't know much about nvarchar but from what I've read, it's similar to varchar. Have you looked at the string functions? You could disallow anything that has double spaces.
Al
C
 		copper21 author 7/25/2012

Thanks for the reply, I will check that out!
Brian
E
 		electromotive 8/1/2012

Have you tried validate with a regular expression? Not to accept space only or leading space?
C
 		copper21 author 8/1/2012

No, I havent...had to work on other stuff on the project, but I am still interested in doing that.