TextColumn depending on database value....
Should be a simple one. I have a database table column "status".. that statuses are encoded as 1,2,3,4,5 and stored as an int.
On the Form used to create the table row, I have a Select:: thus:
...and this works. I render the page, hit the drop down, I see the options "Open", "Closed" etc but it's the number 1, 2, 3 etc goes in the database. Great!
My issue is then how do I display that on the table? I can't find a code snippet to plagiarise to do this! How do I display "Open", "Closed" etc depending on 1, 2, 3 etc in the database?
TIA!
On the Form used to create the table row, I have a Select:: thus:
...and this works. I render the page, hit the drop down, I see the options "Open", "Closed" etc but it's the number 1, 2, 3 etc goes in the database. Great!
My issue is then how do I display that on the table? I can't find a code snippet to plagiarise to do this! How do I display "Open", "Closed" etc depending on 1, 2, 3 etc in the database?
TIA!
