When user registers to system created with ScriptCase, for example Username/Password (admin/AdMiN)
ScriptCase will allow to login with - (admin/admin) (ADMIN/ADMIN) (admin/ADMIN) (ADMIN/admin) end so on.
The option Case Sensitive in SQL Settings is checked to “YES”.
Is this some bug in SC?
Re: Username / Password capitalize
If you select the field in SC and go to VALUES FORMAT, you can change the case settings as needed. Please note that this will change the case of the field AFTER you leave the field. If you want to case to be different at entry, you will have to create a JS function to change the case live.
Regards,
Scott.
Re: Username / Password capitalize
I dont want to create upper case or lower case of same field that is shown as password! If user registers with password AdMin the system should allow him to login with only that password.
select User from dba_users where username = ‘{username}’ and password = ‘{password}’;
if {password} == ADMIN login OK
if {password} == admin login OK
if {password} == Admin login OK
Can you figure it out where the problem is?
Re: Username / Password capitalize
My mistake, sorry.
Please post your code for the onValidate event that accepts your login.
I have a SQL statement, that queries the user table based on the login. If it returns a record, then accepted, else rejected. I do not use an ‘if’ comparison of a value, and the case of the password is obeyed.
Several additional things. If you are comparing a password in code, not very secure. You should use a hash to create/compare password so that A: your password is not plain text, and B: hashes will have different values based on the case of each letter in your password.
example:
$my_pass = md5(‘password’); // 5f4dcc3b5aa765d61d8327deb882cf99
$my_pass = md5(‘pAssWord’); // 1fa2e50c97b358f75a0e039b9c703ef7
Regards,
Scott.