ColdFusion RIA - Ajax

ExtJS 3.0 Editor Grid with ColdFusion + Ext Toolbar Play

Mon, 14 Dec 2009 22:33:00 -0400

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]

Using jQuery based jqGrid with ColdFusion Revisited: Full CRUD grid with Advanced Searching

Mon, 07 Dec 2009 18:55:00 -0400

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:

Inbuilt Form based Add, Edit, Delete and Search functionality
Search is done using new Multiple Search feature
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]

Playing with jQuery UI : Part 1

Mon, 31 Aug 2009 13:25:00 -0400

I downloaded the jQuery UI library a few weeks back (should have done it earlier too). I started playing around with it, but work has been so busy did not get much time to look at it. Finally, found some time to do a basic tabs, accordians, sliders, progress bar demo. Its very basic, good start to learing how some of the things work.

View Demo

The progress bar demo is probably the most complex one, so code for it follows. [More]

jqGrid 3.5 with jQuery UI ThemeRoller Themes Demos

Sun, 02 Aug 2009 14:54:00 -0400

jqGrid 3.5 was released yesterday. It includes lots of good features, including a new rendering engine for faster loading. It also now supports jQuery UI ThemeRoller themes, so to start off itself you have access to variety of styles and can create your own easily too.

So I went ahead and created a demo that shows the grid in all these themes.
View Demo

How I did this style selection switch, follows

[More]

Adding Ext JS Buttons to ColdFusion 9 cfgrid Paging Toolbar

Fri, 24 Jul 2009 13:17:00 -0400

Just a quick post about how to go about adding custom buttons to the cfgrid's paging toolbar. I believe this has changed from Ext 1.1 (which ColdFusion 8 implements) to Ext 3.0 (which ColdFusion 9 implements).

You can see the normal cfgrid here. It comes with no buttons, and it as such with a grid implementation it would suit us if we could show add/edit/delete buttons.

So, you can get your pretty icons and add some nice buttons to the grid allowing users to perform operations. I have one up with an add button.

Code follows

[More]

ColdFusion 9 cfgrid with ORM: Part 1

Tue, 21 Jul 2009 12:30:00 -0400

One of the exciting new feature in ColdFusion 9 is its ORM implementation. ORM in simplest terms allows us to access the database using objects, or in in even more simpler terms you don't have to write any queries for simple CRUD functions. To learn more about ColdFusion 9 ORM visit Adobe's ColdFusion 9 ORM Docs and Introducing ORM in ColdFusion 9 Beta.

This post will look at implementing a cfgrid using ORM. This will be first in a series starting from just implementing the grid to read data ending with a full fledged CRUD cfgrid with ORM.

[More]

Implementing Ext JS Custom Paging Toolbars with ColdFusion 9 cfgrid

Mon, 20 Jul 2009 13:34:00 -0400

If you look at Ext JS examples for 3.0 release you will notice a lot of (New) stuff. The 3.0 release includes a bunch of new plugins to the normal Ext grid framework. A couple of these plugins deal with rendering a different type of paging bar.

Note: The demos/samples for ColdFusion 9 will be a bit slow to load due to them being hosted on a cheap VPS server (the best I could do).

Out of the box, the normal ColdFusion 9 cfgrid has the standard Ext JS paging bar. A demo of the ColdFusion 9 cfgrid can be viewed here: ColdFusion 9 CFGRID.

We will now replace the standard paging bar with a Sliding Pager and a Progress Bar Pager in this blog post.

[More]

Adding ExtJS Row Numbering to ColdFusion cfgrid

Thu, 16 Jul 2009 20:56:00 -0400

With the release of ExtJS 3.0 and the ColdFusion 9 beta I have been digging into the library more. One of the libraries for the grids that ExtJS Core offers is Numbering the grid rows on the current page. ColdFusion doesn't have that option, so I decided to implement it. It was quite simple actually.

Note: This was all done on ColdFusion 9 beta and Ext JS 3.0. ColdFusion 8 ships with ExtJS 1.1 and I am not sure whether the RowNumberer class was present in version 1.1 or not. Also, since we don't have a ColdFusion 9 beta host (or if there is one I haven't found it), you will have to do with screenshots.

So, here is how the grid looks (and this thing looks a lot better than the ColdFusion 8 grid)

[More]

ExtJS 3.0 Grid with ColdFusion 8/ColdFusion 9

Mon, 13 Jul 2009 11:14:00 -0400

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]

Using jQuery based jqGrid with ColdFusion: Part 4: Full CRUD grid with Custom Search Screen

Wed, 04 Feb 2009 21:37:00 -0400

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:

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

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

[More]

ColdFusion and jQuery definition auto-linking (A DB driven implementation)

Sun, 01 Feb 2009 18:33:00 -0400

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]

Using jQuery based jqGrid with ColdFusion: Part 3 : Inline Editing of Data Rows

Fri, 30 Jan 2009 20:56:00 -0400

So, we have now looked:

Creating a basic jqGrid with ColdFusion
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]

Using jQuery based jqGrid with ColdFusion: Part 2 - Filter Records & work with Custom Data

Thu, 29 Jan 2009 12:20:00 -0400

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]

ColdFusion 8 cfgrid vs jQuery jqGrid - Try it Out

Tue, 27 Jan 2009 18:49:00 -0400

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]

Using jQuery based jqGrid with ColdFusion: Part 1

Tue, 27 Jan 2009 00:53:00 -0400

So, this weekend I started looking at jQuery. I have seen many people around the blogosphere use it and it is surprisingly lightweight, and doesn't require a lot of code writing. There is also another problem, the ColdFusion cfgrid implementation slows down as the number of records increase. So, specifically I looked at jqGrid plugin for jQuery to implement a datagrid. I took my previous work on a simple User List grid and started the process of replicating it using jQuery. Thankfully, I was not the first one to think of something like this, so I had a head start thanks Hal Helms So to start off, have a look at the Demo [More]