CFGRIDCOLUMN combobox

Hi all

I have a bog-standard CFGRID that has one column which is a combobox. For some reason the combobox is displaying the value (an integer) rather than the text.

This is my code:

//This is the function that calls up the values for the combo box

<cfinvoke component="#application.comlib#.global" method="Get_Divisions" returnvariable="Get_Divisions">

<cfset lstDivID = ValueList(Get_divisions.divid)>

<cfset lstDivisions = ValueList(Get_divisions.division)>

//This is the grid

<Cfform name="fCategories">

     <cfgrid pagesize="20"

      name="CategoryGrid"

      format="HTML"

      bind="cfc:#application.comlib#.admin.Categories_Get({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"

      onchange="cfc:#application.comlib#.admin.Categories_Edit({cfgridaction},{cfgridrow},{cfgridchanged})"

      title="Categories"

      collapsible="true"

      selectmode="edit"

      delete="yes"

      insert="true"

      autowidth="true">

         <cfgridcolumn name="catid" display="no" />

         <cfgridcolumn name="divid" header="Division" type="combobox" valuesdisplay="#lstDivisions#" values="#lstDivID#"  />

         <cfgridcolumn name="category" header="Category"  />

         <cfgridcolumn name="style_suffix" header="Style Suffix" />

         <cfgridcolumn name="deleted" header="Deleted"  type="boolean" />

   </cfgrid>

</Cfform>

The query that returns the grid content basically looks like this:

SELECT catid, divid, category, style_suffix, deleted FROM categories

where divid is an integer.

When you click on the division column, the combo box renders correctly... it changes to a text value (division from lstDivisions). But if you are not actually in the cell, it displays the integer value (divid from lstDivID)

Am I missing something basic here?

**EDIT**

This problem was apparently fixed in CF 8 using a hotfix as outlined here: http://kb.adobe.com/selfservice/viewContent.do?externalId=kb403597&sliceId=2

We're using CF9.0.1 though....

Thanks

Neal

Message was edited by: Endboss_ZA