Solved

bringing Data in Chunks Coldfusion

Posted on 2011-09-20
11
209 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
Question by:myselfrandhawa
  • 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 15

Author Comment

by:myselfrandhawa
ID: 36565914
i am not using mysql

sorry
0
 
LVL 40

Expert Comment

by:gurvinder372
ID: 36565946
then which one?
0
 
LVL 15

Author Comment

by:myselfrandhawa
ID: 36566107
oracle
0
 
LVL 40

Expert Comment

by:gurvinder372
ID: 36566147
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 15

Author Comment

by:myselfrandhawa
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 15

Author Comment

by:myselfrandhawa
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 15

Author Comment

by:myselfrandhawa
ID: 36600242
nope used the between operator and worked like a charm Thanks
0
 
LVL 15

Author Closing Comment

by:myselfrandhawa
ID: 36600246
thanks for showing a way
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Today I am discussing AJAX problems in IE7 and I bet this will helps many guys out here who have problems with AJAX work. Lets start with the discovery of problem and then we will talk about its different solutions. My last two projects included …
Introduction HyperText Transfer Protocol (http://www.ietf.org/rfc/rfc2616.txt) or "HTTP" is the underpinning of internet communication.  As a teacher of web development I have heard many questions, mostly from my younger students who have come to t…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

708 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now