kgreg
|
| Posted: 09/17/2004, 2:30 AM |
|
I have a integer column in a database that holds 3 values ('123','222','1245')
I have created a non editable grid page to display this column ....
Now here is the challenge.....Instead of displaying 123 I want it to display a different value i.e 123=Help, 222=No Help, 1234 =Sunday....My label in code has the correct control source and data type...I thought it might be in the data format properties section but can't seem to make it work
Thanks for your help in advance
kgreg
|
|
|
 |
BlinkyBill
Posts: 86
|
| Posted: 09/17/2004, 3:58 AM |
|
KGreg,
There are a couple of ways of solving this problem:
1. On the before_show event of the label use your underlying scripting language to substitute the label names for numbers.
2. In your database create a lookup table. Then either create a view with an inner join to the lookup table or just use the query builder in CCS.
I prefer option 2. as if another code comes aloing '5678' = Monday this can be added painlessly with out touching the code and republishing.
Regards
Blinky
|
 |
|
|
