2. PHPRunner General questions
  3. [SOLVED]  Lookup from encrypted fields
This topic is locked
[SOLVED]

 Lookup from encrypted fields

 		1/1/2011 10:36:00 PM
PHPRunner General questions
romaldus author

Based on "Encrypt and decrypt data in the database with PHPRunner 5.3" Tutorial

http://www.asprunner.com/forums/topic/15692-encrypt-and-decrypt-data-in-the-database-with-phprunner-5-3/
INVENTORY_TABLE
(PRIMARY, AUTO INCREMENT)

[b][color="#0000FF"]INVENTORY_NAME (VARCHAR 50)
In my PHPRUNNER project, i encrypt the INVENTORY_NAME field using Pure PHP method.
I face a problem when using lookup wizard to lookup this table from another table (add/edit page) in my project, where link field is INVENTORY_ID and display field is INVENTORY_NAME.
How to decrypt these values on dropdown list, radio button, or check boxes???
Sergey Kornilov admin 1/2/2011

Unfortunately it won't work in current version of PHPRunner as there are no events associated with lookup wizards.
As a workaround you can encrypt/decrypt data right in the database or build this lookup wizard manually via 'Insert PHP code snippet'.
We'll be adding new events to PHPRunner to allow you fine tune lookup wizard controls.
romaldus author 1/2/2011



Unfortunately it won't work in current version of PHPRunner as there are no events associated with lookup wizards.
As a workaround you can encrypt/decrypt data right in the database or build this lookup wizard manually via 'Insert PHP code snippet'.
We'll be adding new events to PHPRunner to allow you fine tune lookup wizard controls.


Thanks.