T
tobleron
Hi, I have an SQL statement like this :
"SELECT * FROM user WHERE userid = '"+ UserIDTxt.getText() +"' AND
passwd = '"+ PasswdTxt.getText() +"'"
and I have an if statement to make selection, whether the userID and
password which are supplied in the form are equal to MySQL data or
not. The datas in MySQL are "test" for userID field and "myecg" for
password field.
When I fill the UserIDTxt with "Test" and passwd with "myecg", or with
other configuration like "TEST" and "MyECG", the result in the if
statement produce "OK" sign. But I want to make it case sensitive.
Only "test" and "myecg" should be produce "OK" sign. How to do it ?
Many thanks in advance.
"SELECT * FROM user WHERE userid = '"+ UserIDTxt.getText() +"' AND
passwd = '"+ PasswdTxt.getText() +"'"
and I have an if statement to make selection, whether the userID and
password which are supplied in the form are equal to MySQL data or
not. The datas in MySQL are "test" for userID field and "myecg" for
password field.
When I fill the UserIDTxt with "Test" and passwd with "myecg", or with
other configuration like "TEST" and "MyECG", the result in the if
statement produce "OK" sign. But I want to make it case sensitive.
Only "test" and "myecg" should be produce "OK" sign. How to do it ?
Many thanks in advance.