One thing i never understand about posts like this:
Who in the world is going to be looking at 10,000 (or more!) rows of
data at once? Are they on an OC3 connection to download the 20 meg
HTML file?
Surely there has to be a better and waaay more efficient way to show
the users the data they want to see
You're digging yourself a deep hole on both the server and client
sides
On Mar 17, 7:20 pm, Brad <nrmlcrpt...@gmail.com> wrote:
> By "Toggle the sort" I'm assuming you want to change a visual sort
> order indicator in the clicked <th>?
>
> As MorningZ suggested your click will fire an ajax .load. The .load's
> callback will:
>
> * populate the tables tbody with the return result set
> * manipulate the clicked th css to indicate a sort order change
>
> I know you mentioned you can't do client side sorting, but I would
> study the Table Sorter plugin and see how they change the sort order
> display. IIRC it involves toggling (or removing/adding) a class that
> has either a background up or down image. You can test the asc or desc
> state of the column by testing for a specific class, .e.g.,
>
> $('th').hasClass('asc');
> $('th').hasClass('desc');
>
> On Mar 17, 12:59 pm, Tony K <tony.kowal...@gmail.com> wrote:
>
> > What would be the best way to Toggle the sort using jQuery?
>
> > Know of any samples that can determine if the sort is asc, then have a
> > toggle update the link to desc?
>
> > I appreciate all your help!
>
> > Thanks,
> > Tony
>
> > On Mar 17, 2:35 pm, MorningZ <morni...@gmail.com> wrote:
>
> > > Sounds like jQuery's ".load" event would be best for you
>
> > > make the call to "list.cfm?show=All&column=name&sort=asc", create the
> > > HTML table in your server side code, then put that HTML into a <div>
> > > or the like
>
> > > On Mar 17, 2:31 pm, Tony K <tony.kowal...@gmail.com> wrote:
>
> > > > I'd like to not have page reloads on the client side, as well as the
> > > > ability to toggle the TH with the sort direction.
>
> > > > Make sense?
>
> > > > On Mar 17, 2:05 pm, MorningZ <morni...@gmail.com> wrote:
>
> > > > > If you are looking to do the sorting on the server-side, then where/
> > > > > how do you think jQuery comes into the equation?
>
> > > > > On Mar 17, 1:20 pm, Tony K <tony.kowal...@gmail.com> wrote:
>
> > > > > > I am looking to display a table of data and have my table headers we
> > > > > > links to sort.
>
> > > > > > I CANNOT use client side sorting, the table is up to 10,000 rows.
>
> > > > > > I have the table built and headers are links to pass a query param.
>
> > > > > > My question is what is the best method to pass the params and load
> > > > > > the
> > > > > > page w/o a refresh.
>
> > > > > > I'd really like the header to know its a toggle, so that ordering
> > > > > > toggles between asc/desc.
>
> > > > > > My example is passing something like this list.cfm?
> > > > > > show=All&column=name&sort=asc
>
> > > > > > This is my first time using jQuery, so any help is appreciated.
>
> > > > > > Thanks,
> > > > > > Tony K
