Encripted psw check
 

Hi,

I have encripted password column in my table. I use VB6 code below to check password but it doesn't work. I think i have to call a function to decrypt it. Where and which function do i use in my sql code below with text1.text.

Thanks

.......WHERE psw=' " & text1.text & " '

Re: Encripted psw check
 

Umm.. Is it related to php ? :-/

Re: Encripted psw check
 

Sorry, this is wrong place for this post.
I do apologise

Re: Encripted psw check
 

Moved to VB section

Re: Encripted psw check
 

Call Decript function before check.

......WHERE Decript(psw)=' " & text1.text & " '

Or
You can encript inputed pasw before check

......WHERE psw=' " & Encript(text1.text) & " '

Re: Encripted psw check
 

Thank you Jx,

I have done it with your solution and solved. In Insert clause encrypt text1 with "AES_ENCRYPT". After i used code below to check text1.

....WHERE AES_DECRYPT(psw, 'text_key') = '" & Text1.Text & "';

Re: Encripted psw check
 

You're Welcome...
Happy coding :)