Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

JQuery Grid with Coldfusion 9 - How to implement?

Posted on 2011-09-26
11
Medium Priority
?
423 Views
Last Modified: 2012-06-21
Hi Experts,

I'm running Coldfusion 9 and I also have jquery for ajax functionality. I'd like to implement a grid object to display results from a query if they are more than 10, then next page. Can someone provide me with pointers or resources on how to implement this with some explanations for a relative jquery noob?
0
Comment
Question by:roger_v
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
11 Comments
 
LVL 15

Assisted Solution

by:Eyal
Eyal earned 400 total points
ID: 36707520
you can use JQGrid
it has tons of options you can use
0
 
LVL 1

Author Comment

by:roger_v
ID: 36707543
@Eyal:

Yes I saw that but I had a bunch of questions on that. Do I need to make ajax calls every time the next set of records are loaded? Would the data returned be in JSON format? In that case, I'm guessing I'll need the JSON parser?
0
 
LVL 15

Expert Comment

by:Eyal
ID: 36707554
you can do whatever you want

or fetch all records and do the paging internally or do ajax for each page
0
Docker-Compose to Simplify Multi-Container Builds

Our veteran DevOps Author takes you through how to build a multi-container environment, managed with a single utility in order to simplify your deployments.

 
LVL 1

Author Comment

by:roger_v
ID: 36707570
I did a google search for a coldfusion implementation and I found CF RIA link but it was too complex for my simple brain to figure out. :)  Is there a good resource that shows a CF implementation of this plugin with ajax calls instead of loading all the data at one time?
0
 
LVL 15

Expert Comment

by:Eyal
ID: 36707592
sorry, I don't remember much from my CF days (7 years ago)
0
 
LVL 16

Expert Comment

by:Gurpreet Singh Randhawa
ID: 36708530
well my Suggestin, Do not use the CFGRID tag which comes inbuild in CF 9. The worst tag i ever encountered
0
 
LVL 82

Assisted Solution

by:leakim971
leakim971 earned 600 total points
ID: 36708547
0
 
LVL 1

Author Comment

by:roger_v
ID: 36709874
@leakim:

So would your suggestion be datatables instead of jQGrid? If so, why?

@myselfrandhawa:

Yeah I've heard the same thing about cfgrid. Is it slow, what exactly is the issue with it?
0
 
LVL 1

Author Comment

by:roger_v
ID: 36709885
@leakim:

Also, this is for a form that I display to the user. The form has a submit button so these tables should be able to accomodate a submit button that verifies all user input as well. So, the page will have a paginated form of content with a submit button at the button. The user can make selections in select boxes and then click submit. Would that work with this layout?
0
 
LVL 82

Expert Comment

by:leakim971
ID: 36711180
>So would your suggestion be datatables instead of jQGrid? If so, why?
Simpler

>Also, this is for a form that I display to the user.
with some work to add functionalities : of course

0
 
LVL 16

Accepted Solution

by:
Gurpreet Singh Randhawa earned 1000 total points
ID: 36712594
I worked with all 3 and here are there concerns

1. CFGRID - becomes difficlt when you need a horizontal scroll bars, Styling becomes difficult, has to work more with underlying EXT JS to bring toolbars and add more functionality

2. DataTables -  Easy to Implement, Good to use with database -  I am actually thinking of creating a CF tutorial of datatables, once i get a bit free - Has some existing Bugs with it. a Better Approach than CFGRID

3. JQGrid -  Overall Perfect -  Good Interface, Easy to Mangle, Migle and Handle Many Options as such

4. Ext JS -  If you use this, I must say Go Ahead. Best Things you will find Here, Awesome Tag if you use directly Ext JS, just check the Documentation and u will never Look back
0

Featured Post

DFW AZURE MEETUP TONIGHT FRI 6PM

We will be discussing what Azure Stack is, how does it fit into the suit of offerings that Azure has currently, and where can it fit into your organizations technology stack. We will also be discussing limitations of the platform while covering various applicable scenarios.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question