Coldfusion 9 CFGIRD not showing data

Posted by Dark Training on April 30, 2010 tags: | coldfusion

In migrating to a new Linux Apache host (CentOS 5.4) and Coldfusion 9 back-end I started having trouble with CFGRID.

What we saw was that if used the CFGRID tag, the actual table would render correctly but no data would appear in the table, CFGIRD would just return an empty box. The closest discussion I could find on the net was this thread in the adobe forums. But unfortunately the thread went un-answered (until I just posted).

The other clue that lead me to the solution was when I tried to switch the form type from Flash to HTML. When I tried this it would throw a java error.

The solution in this case was that we had removed sites from being able to access /CFIDE as a path.

Going into the Apache site settings I added the following line to the site in question:

Alias /CFIDE/  /opt/coldfusion9/wwwroot/CFIDE/
        <Directory "/opt/coldfusion9/wwwroot/CFIDE/">
                AllowOverride None
                Order allow,deny
                Allow from all
        </Directory>

Then I reloaded apahce2:

# /etc/init.d/httpd reload

Voila! Now the grid was not only rendering but rendering WITH data.

I hope this helps someone else out there, if so please feel free to leave a note below.