2. PHPRunner General questions
  3. [SOLVED]  How to apply filters or validations to login page?
This topic is locked
[SOLVED]

 How to apply filters or validations to login page?

 		1/9/2014 15:29:00
PHPRunner General questions
N
 notuo author

Hi.
Any idea? I have the usernames and passwords all Uppercase (even the table is case insensitive) but I need to enter the username and password in uppercase, otherwise is not working.
Any idea to solve this?
Thanks in advance,
Sergey Kornilov admin 1/9/2014

How's about 'Case-insensitive login' option under 'User Login Settings'?
N
 		notuo author 1/10/2014



How's about 'Case-insensitive login' option under 'User Login Settings'?


No, the result is the same. All data in the table is UPPERCASE for those 2 fields (username, password). Is this an issue?
Sergey Kornilov admin 1/10/2014

Case-insensitive login should handle this. It converts both database value and entered value to upper case before comparing.
N
 		notuo author 1/10/2014



Case-insensitive login should handle this. It converts both database value and entered value to upper case before comparing.


Well is not working here. What do you suggest?
Sergey Kornilov admin 1/10/2014

Post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
Sergey Kornilov admin 1/10/2014

Based on project posted to Demo Account - case-insensitive login works, you just need to remember that this option only applies to the login field. Password is always case-sensitive.
If you want to change this behaviour you need to use your own BeforeLogin event issuing SQL query manually and applying upper() function to both username/password fields as well as to both entered . Personally I do not recommend doing this as it weakens the security of your application.