I hadn't looked at the Ext JS library in a while, but this weekend, I took a look at it with the idea of eventually building out a full CRUD grid using Ext JS and ColdFusion. It took some time, particularly trying to figure out the phantom records implementation, but its done now.

View the Demo

And as always, time to look at the code.

[More]

It has been a while since I made my last blog post as work has kept me very busy. Over the weekend I saw that a new jqGrid version had been released and that it contained in-built advanced searching (called multiple search). I also thought it was a good time to revisit my earlier blog post on a full CRUD grid and update it to 3.6 specifications.

This implementation uses the following jqGrid features:

1. Inbuilt Form based Add, Edit, Delete and Search functionality
2. Search is done using new Multiple Search feature
3. Exploration of a few additional colModel parameters

View the Demo : this is all realtime, any updates made will be reflected in the grid.
Now, lets look at the code

[More]

I am personally from Charlotte, so when the CFinNC Conference was announced, it was very exciting. I wanted to get to CFUnited this year but could not make it because of a very busy work schedule, so a weekend conference a few hours away was awesome. And on top of everything it is Free. Let me say that again, it is Free.

They put out a provisional list of speakers and its a very good list. A lot of people who I wanted to listen to in previous conferences will be there.

So head on over to cfinnc.com and register for it.

With the recent release of ExtJS 3.0, I have been looking at the library again. I decided to do a simple Grid implementation using ExtJS. ExtJS is probably one of the best looking JS libraries out there out of the box and when implemented its extremely quick. The main issue as has been when integrading jQuery with ColdFusion was passing the JSON back in the proper format for the grid.

Have a look at the Demo First Here.

[More]

So, previously I blogged about basic jqGrid implementations with Filter/Search and Inline Edit capabilities. The grid here now builds on all that, and implements Add and Delete functionality. I also changed the theme to the new steel theme (available in version 3.4 zip), its much more professional looking compared to the others in my opinion.

This implementation doesn't exactly follow the previous posts. For this grid I am using:

1. Inbuilt Form based Add, Edit and Delete functionality
2. Custom Built Search Dialog Screen
3. Custom Refresh Action
4. Use jqModal for the custom search dialog.

See The Demo. DB being changed realtime, any operations you perform will happen.

[More]

So, this post is inspired by Ray Camden's post on the same subject, Using jQuery and ColdFusion to create an auto-link for definition application, so all credit goes to Ray. I wanted to implement something similar, and also make it database driven as I beleive any implementation of this in an application would be DB driven anyway. You can take a look at the demo here: http://coldfusion-ria.com/test/term.cfm I recommend using Firefox, as I have encountered an issue where the jQuery click event stops working for the first word on IE7 after you click it once.

First things first, the DB structure, looks like this:

The TermName is the term that will be linked, the term HTML is what we will replace the term word with, the TermDef is the definition of the term, and track can be used to track URL clicks.

[More]

So, we have now looked:

1. Creating a basic jqGrid with ColdFusion
2. Implementing the jqGrid Filter functionality

The next step is to allow inline row editing in our grid. This is very simple to implement using jqGrid and it looks good too:

So, to start off, have a look at the Demo. Database is being changed realtime, so any updates you make will happen.

[More]

Continuing to work with jqGrid, this time we will implement its Filter/Search functionality. jqGrid provides an inbuilt filter component, which can be inbuilt into its navigation grid (navgrid), or from a custom pager/toolbar button, or from an external button on your page. This opens in the form of a window (similar to cfwindow):

Check Out the Demo Here

[More]

So, one of the things that led me to look into jqGrid and jQuery was that out of the box cfgrid implementation for CF8 was a bit slower than I expected.

To see this, I put together, two similar implementations in cfgrid and jqGrid, and now you can try it out to see if there is any difference.

cfgrid Implementation

jQuery Implementation

[More]