ssp.class and aes_decrypt()

rapasae

Hello everyone,

Some columns from my database are encrypted with hex(AES_ENCRYPT('field','$key')).
I use SSP::complex( $_POST, $sql_details, $table, $primaryKey, $columns, null, $filter )

How can I use SSP::complex in order to get aes_decrypt(unhex('field'), $key) for some columns from $columns ?
Thanks a lot

allan

The demo SSP class doesn't support SQL functions I'm afraid. You'd need to either modify the class to allow for that or use a VIEW which the class can then read from.

Allan