Antwerp
Posts: 24
|
Posted: 02/28/2005, 7:35 AM |
|
Where and how do I add code and execute custom SQL query for login. My passwords are encrypted in the database. So I want to execute a database function as part of login. Login userID is not encrypted, while the password is encrypted. I have a custom function residing on the database server.
|
|
|
mrachow
Posts: 509
|
Posted: 02/28/2005, 8:39 AM |
|
On Server event OnClick I have first Custom code.
Something like
e.getComponent().getControl("password").setFormattedValue(YourCryptFactory.yourCrypt(e.getComponent().getControl("password").getFormattedValue());
and Action Login added
_________________
Best regards,
Michael |
|
|
Antwerp
Posts: 24
|
Posted: 02/28/2005, 12:27 PM |
|
I changed the query (within buildSql()) in CCSTableAuthenticator.java. It gave me a null point exception. Am I not doing it right?? If there is a piece of code that I can add to my project to execute decryption for login, I would appreciate the help.
|
|
|
Antwerp
Posts: 24
|
Posted: 02/28/2005, 12:32 PM |
|
I want to execute a query such as the following upon the click of my login button:
select userid, password from usertable where userid=loginvalueprovidedby user and mydbfunctiontodecryptpassword(password)=passwordvalueprovidedbyuser
mydbfunctiontodecryptpassword(password) is a function residing in my database.
|
|
|