Question
Logig in CFGRID / CFGRIDCOLUMN
I am using CS3 and ColdFusion 8.
I have a query that populates a cfgrid with no problems. However, I would like to add an extra column. The extra column will be populated according to data elements in the previous columns. For example, five students take a test. I want the Grade Letter column, which is populated with ??, to contain logic that will display A,B,C,D, or F according to their respective Grade Number.
Any ideas on how to do this?
Visual Help Table if I didn't express myself correctly.
<table width="300" border="0">
<tr>
<td>Student Name</td>
<td>Grade Number</td>
<td>Grade Letter</td>
</tr>
<tr>
<td>Student 1</td>
<td>90</td>
<td>??</td>
</tr>
<tr>
<td>Student 2</td>
<td>98</td>
<td>??</td>
</tr>
<tr>
<td>Student 3</td>
<td>80</td>
<td>??</td>
</tr>
<tr>
<td>Student 4</td>
<td>75</td>
<td>??</td>
</tr>
<tr>
<td>Student 5</td>
<td>60</td>
<td>??</td>
</tr>
</table>
I have a query that populates a cfgrid with no problems. However, I would like to add an extra column. The extra column will be populated according to data elements in the previous columns. For example, five students take a test. I want the Grade Letter column, which is populated with ??, to contain logic that will display A,B,C,D, or F according to their respective Grade Number.
Any ideas on how to do this?
Visual Help Table if I didn't express myself correctly.
<table width="300" border="0">
<tr>
<td>Student Name</td>
<td>Grade Number</td>
<td>Grade Letter</td>
</tr>
<tr>
<td>Student 1</td>
<td>90</td>
<td>??</td>
</tr>
<tr>
<td>Student 2</td>
<td>98</td>
<td>??</td>
</tr>
<tr>
<td>Student 3</td>
<td>80</td>
<td>??</td>
</tr>
<tr>
<td>Student 4</td>
<td>75</td>
<td>??</td>
</tr>
<tr>
<td>Student 5</td>
<td>60</td>
<td>??</td>
</tr>
</table>
