Encripted psw check

[veledrom]

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 & " '

[nav33n]

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

[veledrom]

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

[peter_budo]

Moved to VB section

[Jx_Man]

Call Decript function before check. ......WHERE Decript(psw)=' " & text1.text & " ' Or
You can encript inputed pasw before check ......WHERE psw=' " & Encript(text1.text) & " '

[veledrom]

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 & "';

[Jx_Man]

You're Welcome...
Happy coding :)