n42 Designs - Web Development

Filtering a CFGrid

Wed, 12 Aug 2009 11:23:00 -0400

So you want to filter a CFGrid huh? ColdFusion makes this easy!

First you need a CFC method that will return the query used to populate the grid. This method should take the cfgrid parameters and the value you want to filter on.

data.cfc:








>











select * from q

where name like 


order by #arguments.sortcolumn# #arguments.sortdir#

You can see here that I am just hard coding the query in, you would replace this with your cfquery call to your database or a call to your service layer, etc. Once you have your query results, you want to use the queryConvertForGrid method to format the result to a value that CFGrid can work with.

You then need a cfgrid! The trick here is how to get the grid to refresh as the user types a value in the filter box. ColdFusion Ajax UI tools have bind expressions that let us bind one control to another, and to react to events.

index.cfm:

You can see my bind expression in the cf grid. It will call the getData method of my data.cfc and pass in the value from the "filter" input box whenever the key is released. ColdFusion provides other events you can react to as well, check the docs for details.

So now if you run index.cfm you will see a simple form with a text input and a grid. the grid will load when the page is run (bindonload="true") and as you type in the text box, the results are filtered.

EDIT: removed the example link as I have moved this blog to Railo

Webservices Change in CF 8.0.1

Thu, 17 Apr 2008 06:50:00 -0400

It seems with the change to 8.0.1 there is a difference in the way CF generates the stubs for a CFC called as a web service. I had a CFC called webservices.cfc and on 8.0 it was working fine calling the methods, but with the 8.0.1 it started throwing a "duplicate file name" error. This seems to be because CF creates its own stub file Webservices.java and also a [cfcname].java file. CF couldn't create both so it threw an error. The solution was to rename my CFC. The stubs can be found in C:\ColdFusion8\stubs\ on windows, and if I remember correctly /Applications/ColdFusion8/stubs/ on Mac OS X.

Issue w/ Eclipse Resource Bundle Editor Plugin and Leopard

Thu, 17 Jan 2008 18:18:00 -0400

There seems to be an issue with the Resource Bundle Editor Plugin for Eclipse. (http://sourceforge.net/projects/eclipse-rbe/) I installed version 0.7.7 into a fresh install of the Eclipse 3.3 SDK and was unable to open a resource file. I would get the following error:


Can't start the AWT because Java was started on
the first thread. Make sure StartOnFirstThread is not specified in your
application's Info.plist or on the command line

To fix it I edited the eclipse.ini file (/Applications/eclipse/Eclipse.app/Contents/MacOS/eclipse.ini by default) to add the following line:


-Djava.awt.headless=true

Once I did that it was fine and I was able to edit the resource bundles. Hope this helps someone searching for the issue!