ColdFusion RIA - ColdFusion 8

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]

Registration for CFinNC Conference Open (Free ColdFusion based Conference)

Tue, 25 Aug 2009 15:17:00 -0400

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.

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]

ColdFusion 8 cfgrid adding Add and Delete Record Functionality

Wed, 21 Jan 2009 15:55:00 -0400

The ColdFusion 8 cfgrid offers us an excellent interface to allow our application users to perform administrative tasks on table data. Two fundamental functions on table data include the ability to Add a Record and the ability to Delete a Record. So, I modified the cfgrid that has been built till now (blogged previously) to include Add/Delete functionality. You can look at a Demo Here [More]

Yahoo User Interface (YUI) Base CSS with Coldfusion 8 cfgrid conflicts

Sat, 17 Jan 2009 18:11:00 -0400

So, while working on integrating the cfgrid with my demo application, I came accross a conflicts with the CSS that ColdFusion expects to produce for an HTML cfgrid versus the CSS markup from the YUI Base CSS component. Check It Out Here So, what the Base CSS package does is,

applies a consistent style foundation for common HTML elements

This creates a conflict with the ColdFusion CSS package (which is based on Ext 1.1.1 API). At the same time, you could use this to extend the Base CSS file and define your own styles for the elements. Right now, I just removed Base CSS from my application.

ColdFusion 8 cfgrid - Implementing User Selected PageSize and using YUI Dom Collection Library

Thu, 15 Jan 2009 18:46:00 -0400

Previously I blogged about implementing a filter feature and ability to show/hide columns in the grid Here. We are going to make another small enhancement to it, we will allow the User to select how many records to display per page (from a pre-defined list). We will also use some powerful Yahoo User Interface (YUI) Do functions to implement this.

A new demo is available Here.

[More]

ColdFusion 8 cfgrid - Filter Grid Data, Show/Hide Columns and using the YUI Buttons Library

Tue, 13 Jan 2009 14:08:00 -0400

The next step in the Project will be the User Administration page. The idea for the administration pages is simple:

Pagination (min 10 records per page)
Sorting on all columns
Ability to Filter grid Data by various columns
User Preferences to show/hide columns on the grid
Add/Edit/Delete Function Access from grid page

The ColdFusion 8 cfgrid implementation allows us to accomplish points 1 and 2 out of the box. CF8 Ajax featurs will allow us to accomplish point 3. Further looking into the ExtJS library means we can do 4 too. We will worry about point 5 for later. First, check out the little Demo: cfgrid demo

[More]

Implementing Browser History Management to the Application

Mon, 12 Jan 2009 11:42:00 -0400

I previously blogged on the YUI History Manager (read it up if you haven't). I just got around to implementing it to an Application

Now, I like to include my javascript at the top of the page (and I think most people do). This meant I had to switch some things around.

[More]