Skip to main content
A
Anonymous
April 21, 2008
Question

cfgridcolumn value question

  • April 21, 2008
  • 2 replies
  • 311 views
Hi,

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!

cfwild
This topic has been closed for replies.

2 replies

J
Jerrywall
Participant
April 22, 2008
I'd just access the contents via Javascript and reformat them... using something like this...

P
paross1
Participating Frequently
April 21, 2008
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.

Phil
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices