mysql Function in grid application / funciones Mysql en applicaciones grid

Scriptcase 8 Discussion
#1

Hello,

I have en SQL in my grid app the uses AES_ENCRYPT:

SELECT
GRUPO,
aes_decrypt(apellido,‘mykey’) as apellido,
nombre,
dni,
email
FROM
vw_grupo_per

But it not works!!! return the info without decrypt!!

If I run in mysql works fine. If I use events in form applications works fine. But in grid nothing works!!

Please help!!!

#2

translade the decription from mysql to php, mysql tends to do weird stuff encryption wise… so my recomendation, make the select with the plain fields… and in you php decode the aes value…

Regards

#3

[QUOTE=kafecadm;35651]translade the decription from mysql to php, mysql tends to do weird stuff encryption wise… so my recomendation, make the select with the plain fields… and in you php decode the aes value…

Regards[/QUOTE]

Gracias!! En la sintaxis de

string mcrypt_decrypt ( string $cipher , string $key , string $data , string $mode [, string $iv ] )

Sabes que va en el parametro “cipher” para el decrypt cuando se encripto usando aes de mysql?

saludos y gracias de nuevo!

#4

AES en pocas palabras el tipo de encriptaci?n

AES or in other words the type of encription

check this out

http://php.net/manual/en/mcrypt.ciphers.php

btw… try not to mix languages in the forum people don’t tend to take that to well lol.

Regards

#5

I followed your recomendation using “onRecord” event tranforming each encrypted field to plain value. works fine!

Thanks you, you are helping me a lot.