Thanks for the tip, Marco.
Rick From: jquery-en@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Web Specialist Sent: Sunday, April 13, 2008 2:42 PM To: jquery-en@googlegroups.com Subject: [jQuery] Re: How do I use ColdFusion and jQuery variables for pagination? Hi Rick. I have an app with ColdFusion and jQuery Flexigrid plugin to do pagination for large datasets. I'm using this approach: 1) using spSelectNextN stored procedure(SQL Server). This sp is a great job by Dan G. Switzer(http://blog.pengoworks.com/index.cfm/2006/6/19/MSSQL-2k-Stored-Procedure-for-Pagination) 2) using Flexigrid plugin(http://webplicity.net/flexigrid/) With this your application will display only 10(15, 20, 50 etc) records/page. If you need examples please contact me. Cheers Marco Antonio On 4/10/08, Rick <[EMAIL PROTECTED]> wrote: Thanks, Josh... I'll work on that route. Rick On Apr 10, 4:48 pm, "Josh Nathanson" <[EMAIL PROTECTED]> wrote: > Rick, if you have 10,000 records, I would say to not dump them all into the > client. > > My suggestion would be to set everything up as if you were doing the > pagination on the server using CF, and then change your pagination links so > that they are intercepted, and used to do an ajax call to your CF template > which retrieves the records. > > Your CF template could output the records as an html table and then send > that html back to the client -- this html would be the argument in your ajax > callback function, which would take the returned html and place it in the > right place on the page. > > This is all independent of any plugins, just using straight jQuery and CF. > > Just as a rough outline... suppose your pagination link looks like <a > href="myCfTemplate.cfm" class="paginate">5</a> (this would be to go to page > 5 of the pagination). > > Your ajax call would look like something like: > $("a.paginate").click(function() { > $.get( > this.href, > $(this).text(), > outputhtml > ); > return false; > > }); > > Where "outputhtml" is the function that takes the returned html and outputs > it to the page. This would send the data "5" to your CF template as an url > variable, which you could use to determine which records to get from the > database. > > -- Josh > > > > ----- Original Message ----- > From: "Rick" <[EMAIL PROTECTED]> > To: "jQuery (English)" <jquery-en@googlegroups.com> > Sent: Thursday, April 10, 2008 1:17 PM > Subject: [jQuery] Re: How do I use ColdFusion and jQuery variables for > > pagination? > > Thanks for the reply, Josh... > > I think the part that I'm not understanding is the "dump the whole > query > to the client and then the plugin takes care of the pagination." > > It also sounds like a memory and/or processor intensive way to get 20 > records > per page. If I have 10,000 records, I guess I would be getting and > dumping > all 10,000 records at once? > > I've considered taking the straight CF route with this, or perhaps > using SQL > to retrieve just the records I need. > > Would using CF or SQL be preferable for datasets composed of thousands > of records? > > Rick > > On Apr 10, 3:31 pm, "Josh Nathanson" <[EMAIL PROTECTED]> wrote: > > Rick - I don't know how the pagination plugin that you're using works, but > > there may be some sort of "before" event that you can use to ajax some > > variables to your CF page. Your CF template would take these variables and > > use them to set the startrow and maxrow values and then send back the > > result. > > > That said, not sure why you'd need to do that if you're doing pagination > > on > > the client side? The idea is that you dump the whole query to the client > > and then the plugin takes care of the pagination. > > > -- Josh > > > ----- Original Message ----- > > From: "Rick Faircloth" <[EMAIL PROTECTED]> > > To: <jquery-en@googlegroups.com> > > Sent: Thursday, April 10, 2008 12:19 PM > > Subject: [jQuery] How do I use ColdFusion and jQuery variables for > > > pagination? > > > > Hi, all... > > > > I'm a bit confused about how to get variables from jQuery that > > > I can use in my ColdFusion code. > > > > In typical CF pagination, I use startrow and maxrows variables > > > to limit the query output. How would I get these variables > > > from the jQuery? > > > > I just can't piece together what's happening. > > > > Below is the jQuery I'm currently using. The total number > > > of records is set in the jQuery using the recordCount CF variable. > > > > Thanks for any help! > > > > Rick > > > > <script type="text/javascript"> > > > > function pageselectCallback(page_id, jq){ > > > $('#Searchresult').text("Showing search results > > > "+((page_id*20)+1)+"-"+((page_id*20)+20)); > > > } > > > > $(document).ready(function(){ > > > // Create pagination element > > > > $("#Pagination").pagination(<cfoutput>#get_properties.recordCount#</cfoutpu--t>, > > > { > > > items_per_page:20, > > > num_edge_entries: 2, > > > num_display_entries: 20, > > > callback: pageselectCallback > > > }); > > > }); > > > > </script>- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text -