Solved

bringing Data in Chunks Coldfusion

Posted on 2011-09-20
11
212 Views
Last Modified: 2012-05-12
Hi, I am making one ajax call as:

$.ajax({ type:"POST", url:"welcome.cfm", data: data, success: function (html) { $('#message').html(html); } }); return false;

So now i want that i should return 100 records first time it calls that Page, now i want to apply the Paging to that also. So when i cick the next record or any number in paging say 5, it should display that data and make an ajax call to get that data, this way i think it will be better to handle millions of records!

Also i cannot use cfgrid, jquery preferred. if i can get the data as JSON and parse on client ide, i think that can make performance faster!

Guide


0
Comment
  • 6
  • 4
11 Comments
 
LVL 40

Expert Comment

by:gurvinder372
ID: 36565885
if you are using mysql, then why don't you use limit and offset to get only that many number of rows from database
0
 
LVL 16

Author Comment

by:Gurpreet Singh Randhawa
ID: 36565914
i am not using mysql

sorry
0
 
LVL 40

Expert Comment

by:gurvinder372
ID: 36565946
then which one?
0
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 
LVL 16

Author Comment

by:Gurpreet Singh Randhawa
ID: 36566107
oracle
0
 
LVL 40

Expert Comment

by:gurvinder372
ID: 36566147
0
 
LVL 16

Author Comment

by:Gurpreet Singh Randhawa
ID: 36566636
well if i get a sample for this that will be good
0
 
LVL 39

Expert Comment

by:gdemaria
ID: 36566690
I would think you need to pass the page number to the ajax call, otherwise how will the query know which page of 100 records to return?   It may be even better to pass both page number and page size (in case you want to allow the user to vary their page size in the future)
0
 
LVL 16

Author Comment

by:Gurpreet Singh Randhawa
ID: 36566764
yes that will be, but how. that is confusion
0
 
LVL 40

Accepted Solution

by:
gurvinder372 earned 500 total points
ID: 36566823
something like

SELECT * FROM
   (SELECT ename FROM emp ORDER BY dbms_random.value())
WHERE rownum >= 1 and rownum <=10;

1 and 10 values can come from a variable which will be evaluated based on the pagination logic
0
 
LVL 16

Author Comment

by:Gurpreet Singh Randhawa
ID: 36600242
nope used the between operator and worked like a charm Thanks
0
 
LVL 16

Author Closing Comment

by:Gurpreet Singh Randhawa
ID: 36600246
thanks for showing a way
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

828 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