Skip to main content
Known Participant
Mar 28, 2008 3:45 PM UTC
Question

Display data in full description!

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 is closed to new replies. Start a new post to keep the conversation going.

    5 replies

    Inspiring
    Mar 29, 2008 3:57 PM UTC
    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/
    Translate
    avt2k8Author
    Known Participant
    Apr 1, 2008 2:53 AM UTC
    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.
    Translate
    avt2k8Author
    Known Participant
    Mar 28, 2008 4:43 PM UTC
    I posted the question and just found the answer by using cfswitch and cfcase. Never mind!
    Translate
    avt2k8Author
    Known Participant
    Mar 28, 2008 4:43 PM UTC
    I posted the questions and just found the answer by using cfswitch and cfcase. Never mind!
    Translate