CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> Java

 Execute Custom SQL for Login

Print topic Send  topic

Author Message
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.
View profile  Send private message
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
View profile  Send private message
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.
View profile  Send private message
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.

View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.