Skip to main content
Participant
February 16, 2009
Question

cfgrid bug display of data

  • February 16, 2009
  • 1 reply
  • 418 views
Hi

I have a cfgrid with pagination, using the bind parameter to get the data. The table I'm displaying has a column CountryCode nvarchar(2) with value NO for Norway. But in the cfgrid FALSE is displayed. How can I disable the data conversion or interpretation ? I added type="string_noCase" to the gridcolumn. I added Cast as nvarchar(2) in the query used in the bind parameter. But nothing helps. The data returned by the function used in the bind parameter is correct.

the cfgrid I use:
<cfgrid name="AirportsGrid"
format="html"
selectmode="row"
pagesize="35"
bind="cfc:cfcs.GetDataAirports({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"
onError="errorhandler"
sort="yes"
colHeaderBold="yes"
rowHeaders="yes"
textColor="##000000"
stripeRows="yes"
stripeRowColor="##DFDFDF">

We need help !

Thanks in advance,
Tamara Vos
This topic has been closed for replies.

1 reply

Participating Frequently
March 19, 2010

Did you ever find the answer?  My grid is also showing true/false for my "active1" column.

My query looks something like: select title, case active when 1 then 'Yes' when 0 then 'No' else null end active1 from ...