I am pulling back a query that is populating a cfgrid cell
with either a 1 or a 2. Instead of the 1, I'd like the grid to
display "No", instead of 2, display "Yes".
If anyone has any thoughts on how to do this, I'd appreciate
it!
You could do it in the query, rather than in the output. What
database are you using? Oracle has a DECODE() function specifically
for changing one value to another, and most databases will support
using a CASE statement in the SELECT, where you can perform
conditional changes.
2
Replies
AdChoices