Skip to main content
Known Participant
March 28, 2008
Question

Display data in full description!

  • March 28, 2008
  • 3 replies
  • 416 views
Hello all,

I need to display the column data from a table into cold fusion page. In my database, they use abbreviation alphabet for simple inputs.

For example: table student

ID | name | grade
1| Jeff | A
2| Julia| B
3| Bob|C

How do I can output the data with full grade description in cold fusion page as following:

Name | Grade
Jeff A=90-100
Julia B=80-90
Bob C=70-80

Any help is much appreciated. Thanks in advance.
    This topic has been closed for replies.

    3 replies

    Inspiring
    March 29, 2008
    your answer is not running another query in your cfcase part, is it?
    hope not...


    Azadi Saryev
    Sabai-dee.com
    http://www.sabai-dee.com/
    avt2k8Author
    Known Participant
    April 1, 2008
    Hi,

    I did not have any other query in cfswitch and cfcase. Just evaluate the expression for column field and convert the abbreviation to full description in display.
    avt2k8Author
    Known Participant
    March 28, 2008
    I posted the question and just found the answer by using cfswitch and cfcase. Never mind!
    avt2k8Author
    Known Participant
    March 28, 2008
    I posted the questions and just found the answer by using cfswitch and cfcase. Never mind!