Milind...jQuery is really pretty easy once you understand the foundation of how to interact with, and act upon, page elements via classes and IDs. I picked up a copy of the book Jquery Compressed (linked below) on my iPad Kindle app for $4. If you have a Kindle, its free. Its a good tutorial for jQuery with some real examples.
On Thu, Apr 18, 2013 at 5:05 PM, Milind Pataskar <[email protected]> wrote: > A BIG Thanks if you can do that. > > By the way, I remember, I had used the jQuery tabs once, almost 2 years > back. But I had not > incorporated any dynamic data (loads) in that. It was purely using a > <ul><li></ li></ ul> > to convert into tabs. > > Milind. > > ------------------------------ > Date: Thu, 18 Apr 2013 16:58:50 -0500 > Subject: Re: [houcfug] Help with Dynamic Data Scrolling > From: [email protected] > To: [email protected] > > I could probably whip something up this evening > > > On Thu, Apr 18, 2013 at 4:57 PM, Milind Pataskar <[email protected]> wrote: > > I guess I will have to try something like that. > > So you have any code / link that I can use? > > Milind. > > ------------------------------ > Date: Thu, 18 Apr 2013 16:49:14 -0500 > > Subject: Re: [houcfug] Help with Dynamic Data Scrolling > From: [email protected] > To: [email protected] > > > Ok, how about this. > > Load all of your tabs via ajax calls, pulling only the first x rows of > data. The cfc or cfm on the back side only returns a few rows at a time, > beginning with the row you specify. A Little jQuery to keep track of the > rows and to detect when the bottom of the tab is showing should do the > trick. > > On the first ajax call pull the full record set and store it in the > session. The use QoQ to pull the rows you want using startrow/maxrows > > M > > > On Thu, Apr 18, 2013 at 4:41 PM, <[email protected]> wrote: > > That example is infinite scrolling – it’s simply giving the user visual > feedback, like Twitter does, versus scrolling in a table, where the effect > is less obvious (the scroll bar grabber changes size as more content is > loaded in).**** > ** ** > As for offering the user many controls (action icons) as you mentioned, > you can certainly use a primary icon that triggers a popup or dropdown box > containing all the tools they need – Bootstrap’s Dropdown offers this > feature, and there are other JQuery tools similar to it out there.**** > ** ** > If there are many joins (and I know you don’t have access to the person > who created the table), a stored procedure might be another way of > approaching the problem (I’ve used a SP before when pulling together a > large recordset with many joins to save on load time).**** > ** ** > *James E. Thomas* > *Baker Botts L.L.P.*** > *Development Manager, IT Practice Support* > O: 713.229.2196 | M: 832.373.8117 | F: 713.229.8130**** > ** ** > *From:* [email protected] [mailto:[email protected]] *On > Behalf Of *Milind Pataskar > *Sent:* Thursday, April 18, 2013 4:27 PM > *To:* [email protected] > *Subject:* RE: [houcfug] Help with Dynamic Data Scrolling**** > ** ** > Mike, > > You are essentially correct. I am trying to borrow that idea from the > mobile devices. > > The following example shows what I want to do (except no in an infinite > way): > > http://alphacommunications.com/search.php?find=ir > > If you scroll all the way down, it shows a spinner and load a set number > of rows to display. > > Any help? > > Milind.**** > ------------------------------ > From: [email protected] > Date: Thu, 18 Apr 2013 16:21:17 -0500 > Subject: Re: [houcfug] Help with Dynamic Data Scrolling > To: [email protected]**** > Miland,**** > ** ** > We do that in our apps. We actually load 50, and when the user scrolls > to the bottom we dynamically load 50 more > > Sent from my iPhone**** > > On Apr 18, 2013, at 4:15 PM, Milind Pataskar <[email protected]> wrote:**** > > Ken, > > I wont get access to the DBA and probably the tables are correctly > indexed. The loading is slow because the page is > loading multiple queries (that the user may or may not be interested) for > other tabs as well. > > Our main concerned table has got many joins (and surely the other > un-needed query/tables as well). Probably that > is what is causing the actual query to load slow. > > Maybe my 200 row number was small. What if there were 400 total rows to be > selected and shown. But I want to > show only 100 on the first load and perhaps load and show 50 rows every > time the user scroll at the bottom of the page. > > James Thomas, > > I will look at the *datatables *link but I need to show quite a few > actions icons on every row. Do not know if your solution > allows that. > > > Thanks guys for you help. Keep on sending. > > Milind.**** > ------------------------------ > From: [email protected] > Date: Thu, 18 Apr 2013 15:54:33 -0500 > Subject: Re: [houcfug] Help with Dynamic Data Scrolling > To: [email protected]**** > Milind,**** > Because you through out the number 200, I don't think dynamic data load > will help you here...**** > The dynamic load and infinite scroll solutions are only really helpful > if you are only showing a very small percentage of the data at one time. > since you want 25%, you may as well pull it all in at once.**** > Your speed problem is more than likely that you need more proper indexes > on the DB tables.**** > If you work on the DB performance, and set it up to load the data for > each tab when you go to that tab, then pulling 200 records should be pretty > fast.**** > ** ** > HTH!**** > > **** > --Ken**** > ** ** > On Thu, Apr 18, 2013 at 3:35 PM, Milind Pataskar <[email protected]> > wrote:**** > Hello all, > > Our query returns a huge data and I need to cut down on the on the page > load time. > > To further complicate the matter, the page has got multiple tabs and upon > a quick glance, > I realize that they are running all the queries for all the tabs at the > beginning. But only the > contents of the current tab are shown. > > SO: For now lets even ignore the loading of all queries for all tabs. > All I'm concerned is how do I load and show the first 50 rows returned > from the query > and then have a "On Demand Data Load" and "Dynamic Data Scrolling". > > Mind you, I do not want the "Infinite Scroll" because my table has a > finite data (lets say 200 rows). > > I tried searching solutions in jQuery and AJAX but there is too much > information to sift from. > > Has anybody successfully implemented Dynamic Data Scrolling (with a > spinner as the data > is being fetched) ? > > Please help. > > Thanks, > > Milind.**** > > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > **** > ** ** > > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > **** > > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > **** > > > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > **** > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > **** > *Confidentiality Notice:* The information contained in this email and > any attachments is intended only for the recipient[s] listed above and may > be privileged and confidential. Any dissemination, copying, or use of or > reliance upon such information by or to anyone other than the recipient[s] > listed above is prohibited. If you have received this message in error, > please notify the sender immediately at the email address above and destroy > any and all copies of this message. > > > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > > -- > -- > You received this message because you are subscribed to the "Houston > ColdFusion Users' Group" discussion list. > To unsubscribe, send email to [email protected] > For more options, visit http://groups.google.com/group/houcfug?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Houston ColdFusion Users' Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en --- You received this message because you are subscribed to the Google Groups "Houston ColdFusion Users' Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
