Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

JQuery Grid with Coldfusion 9 - How to implement?

Posted on 2011-09-26
11
Medium Priority
?
431 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
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 83

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 83

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
JavaScript can be used in a browser to change parts of a webpage dynamically. It begins with the following pattern: If condition W is true, do thing X to target Y after event Z. Below are some tips and tricks to help you get started with JavaScript …
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…
Suggested Courses

577 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