Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

JQuery Grid with Coldfusion 9 - How to implement?

Posted on 2011-09-26
11
Medium Priority
?
428 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

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.

Question has a verified solution.

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

Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
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

886 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