[FX.php List] AJAX Big Picture

[biscuit technologies]

Hi again,I'm not so familiar with setting SESSIONs and I've been doing some
reading  up on it.
Roughly, I have a layout that shows four columns of data and I want to
provide the ability to sort two of the columns either by themselves or
sequentially:
Sort by ColA
Sort by ColB
Sort by ColA, then B
Sort by ColB, then A

I was thinking to do this with a series of pulldowns and AJAX so I can stay
on one page and refresh the data without refreshing the rest of the page.
The key need here is to be able to do the sorting within a found set, so if
I do a find and reduce the found set to 50 records, I want to be able to
sort just those records.

Would I be able to do this by setting SESSION? I'm having a hard time
understanding how to go about saving that found set so I can do things with
it.

If it helps, I don't need to send any edits back to the db, this is all just
information presentation.

Thanks,
David


2008/7/24 Jonathan Schwartz <jschwartz at exit445.com>:

>  I had the same question myself today...
>
> I needed to split the results of a query into two columns. My first attempt
> was to create two separate queries, one to retrieve each half of the
> records.  After some thought, I realized that I could just retrieve the
> entire record set in one query, write it to an array, and then create the 2
> columns from the array.  After even more thought, I realized that this
> particular data set was not very dynamic.  I decided to tell the page to
> re-use the array saved to SESSION on the first query, rather than reissue
> the query each time.
>
> That's how I managed to minimize server load in this case.
>
> HTH,
>
> Jonathan
>
>
> At 7:11 PM -0700 7/24/08, biscuit technologies wrote:
>
> Thanks for all the info, it helps. I write everything in a text editor, so
> I think I'm going to try jQuery to start.
>
>
> I know this is a dumb question - but I want to know what others think:
>
> What is the best way to write multiple queries in a single page?
>
> Since I think I'm going to end up with more hits to the db on each page
> load I want to be sure I do things in the most efficient way.
>
>
> thanks,
>
> David
>
>
>
>
>  On Thu, Jul 24, 2008 at 5:25 PM, Tim 'Webko' Booth <tim at nicheit.com.au>
> wrote:
>
>
> On 25/07/2008, at 9:30 AM, Jonathan Schwartz wrote:
>
> Phew!
>
> Thanks for the overview, everyone!
>
> In summary, does that mean that Spry, jQuery, prototype  and LaJax are
> different flavors of the same animal?  You choose to use one or the other?
>
>
> That would generally be the case, but I have been known to steal a chunk
> from one of them for particular purposes, even if I don't use the entire
> library of stuff...
>
> And I don't choose dev browsers - I'll use whatever one happens to be open,
> and then test stuff on all the others (and you *really* do have to have
> access to IE - it's quirks mode drives me batty as it consistently breaks on
> valid html and does explode the page to all corners of the screen...)
>
> Cheers
>
> Webko
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
>
> --
>
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-370-5011
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://localhost/pipermail/fx.php_list/attachments/20080725/7e855abe/attachment-0001.html