2. PHPRunner General questions
  3. [SOLVED]  dropdown with encrypted data
This topic is locked
[SOLVED]

 dropdown with encrypted data

 		3/22/2021 11:13:15 AM
PHPRunner General questions
M
 Mauipm author

Hi,

I need to populate a dropdown list (or even field in the forms) concatenating fields that are encrypted in the db table;

How can I do that? Using Concat I get encrypted data

Any suggestion?

Thanks in advance

Mauro
Sergey Kornilov admin 3/22/2021

You cannot do this. Concat won't work with encrypted data.
You can check examples of decryption at https://xlinesoft.com/phprunner/docs/encryption.htm. You can decrypt your data first and then concat it. This will be cumbersome though and it will also require you to specify the description key right in the Custom Expression of the lookup wizard.
M
 		Mauipm author 3/23/2021



You cannot do this. Concat won't work with encrypted data.
You can check examples of decryption at https://xlinesoft.com/phprunner/docs/encryption.htm. You can decrypt your data first and then concat it. This will be cumbersome though and it will also require you to specify the description key right in the Custom Expression of the lookup wizard.


Thank you Sergey, I'll try in that way
Mauro
Myr0n 3/23/2021



You cannot do this. Concat won't work with encrypted data.
You can check examples of decryption at https://xlinesoft.co...encryption.htm. You can decrypt your data first and then concat it. This will be cumbersome though and it will also require you to specify the description key right in the Custom Expression of the lookup wizard.


Hi Sergey

Can you correct the link that you reference please. thank you
When I click said "

Server Error in '/' Application.
The resource cannot be found.

Description:HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.
Requested URL:/phprunner/docs/encryption.htm.
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.3535.0"
M
 		Mauipm author 3/24/2021



Hi Sergey

Can you correct the link that you reference please. thank you
When I click said "

Server Error in '/' Application.
The resource cannot be found.

Description:HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.
Requested URL:/phprunner/docs/encryption.htm.
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.3535.0"
M
 		Mauipm author 3/24/2021



Hi Sergey

Can you correct the link that you reference please. thank you
When I click said "

Server Error in '/' Application.
The resource cannot be found.

Description:HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.
Requested URL:/phprunner/docs/encryption.htm.
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.3535.0"


The problem is just the final DOT into the link: https://xlinesoft.com/phprunner/docs/encryption.htm
Myr0n 3/24/2021



The problem is just the final DOT into the link: https://xlinesoft.co.../encryption.htm


Thank you