This topic is locked

Lookup wizard List of values

6/4/2014 9:41:12 AM
PHPRunner General questions
T
TheOmda author

Dears,
I Have a problem that my database fields contains many enumerator values that be represented in the database with (INT,TINYINT) and solved to enumerator item in the application
first I want to replace the fetched INT value into string to friendly display i.e. ( database value of STATUS field = 1 and it represent status (Running) )

Second I want the same thing in the Add Page i.e. ( User select (Running) from dropdown and the actual value that will save to database is 1)
Regards

Sergey Kornilov admin 6/4/2014

I would recommend to create an additional lookup table with the following structure:

ID Status

---------

1 Running

2 Not running


This is the only way how you can handle this.