Is it possible to apply MySQL functions when saving data to a database?
For example, in my Save Data function I have added a data override for "comments" with the value: AES_ENCRYPT('{data:comments}', 'mykey')
But when I look at the debug info, this is what it the query ends up looking like:
I appreciate any advice!
For example, in my Save Data function I have added a data override for "comments" with the value: AES_ENCRYPT('{data:comments}', 'mykey')
But when I look at the debug info, this is what it the query ends up looking like:
INSERT INTO `mytable` (`id`, `comments`) values ('', 'AES_ENCRYPT('test comment', 'mykey')');I could just write it with custom code, but that's what I've been doing with v5 so I was hoping v6 would have a better way.
I appreciate any advice!
This topic is locked and no more replies can be posted.