An update.

this line: <CFSET temp = ArraySet(course_idarray, 0, b, "N/A")>

Should be: <CFSET temp = ArraySet(course_idarray, 1, b, "N/A")>

Hi BKBK!

I appreciate your assistance.  What appears to have been the problem here from some research that I did is that a Cold Fusion array does not start with zero, it starts with 1.  So I changed the array to: "

<CFSET temp = ArraySet(bucketarray, 1, 2, crosstabquery.amount)>" so that the count starts with 1 and the next count is 2.

Here is my updated code, for which as you can see below the COUNT that I added is not working properly.

<CFQUERY NAME="crosstabquery" DATASOURCE="LIISthinkgate">
  SELECT distinct teacher_anumber,dsckcrse,dscgrd,  count(dsckextid) as amount
    FROM evaluationstudentcourse
    WHERE teacher_anumber = 'A054863'
    group by teacher_anumber,dsckcrse,dscgrd
  ORDER BY teacher_anumber,dscgrd,dsckcrse
</CFQUERY>

<CFQUERY NAME="crosstabcolumns" DBTYPE="query">
  SELECT distinct dsckcrse
    FROM crosstabquery
    WHERE dsckcrse = crosstabquery.dsckcrse
  ORDER BY dsckcrse
</CFQUERY>

<CFSET bucketlist = ValueList(crosstabcolumns.dsckcrse)>

<CFSET bucketheaders = ListToArray(bucketlist)>

<CFSET b = ArrayLen(bucketheaders)>

<CFSET bucketarray = ArrayNew(1)>

<CFSET temp = ArraySet(bucketarray
                  , 1, b, "N/A")>

<CFOUTPUT QUERY="crosstabquery" GROUP="teacher_anumber">
  <h4>Anumber=#teacher_anumber#</h4>
  <table border="1" cellpadding="5">
  <tr><th></th>
  <CFLOOP INDEX="i" FROM="1" TO="#b#">
    <th>#bucketheaders[i]#</th>
  </CFLOOP>
  </tr>
  <CFOUTPUT GROUP="dsckcrse">
    <tr><th>#dscgrd#</th>
  
  
       <CFSET i = ListFind(bucketlist
                  , crosstabquery.dscgrd)>
        <CFSET temp = ArraySet(bucketarray
                     , 1, 2, crosstabquery.amount)>
 
    <CFLOOP index="j" FROM="1" TO="#b#">
      <td>#crosstabquery.amount#</td>
    </CFLOOP>
    </tr>
    </CFOUTPUT>
  </table>
</CFOUTPUT>

I got rid of the original error, however I am now not getting "0" where there should be no count. For instance 5001020 (dsckcrse), 02 (dscgrd) should have 136.  The others (01,03,04,05,KG) should be zero.  I get the following:

Anumber=A054863

Appreciate any insight you have.