Solved

bringing Data in Chunks Coldfusion

Posted on 2011-09-20
11
210 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 15

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
 
LVL 15

Author Comment

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

Expert Comment

by:gurvinder372
ID: 36566147
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 15

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 15

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 15

Author Comment

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

Author Closing Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction A frequently asked question goes something like this:  "I am running a long process in the background and I want to alert my client when the process finishes.  How can I send a message to the browser?"  Unfortunately, the short answer …
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

910 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

22 Experts available now in Live!

Get 1:1 Help Now