At 10:55 AM 09/24/03, Stan Ou wrote:
>Hi all,
>
>I have a sql query that joins 5 or 6 tables that
>returns 100 to 200 records. The result is wrapped in a
>VO and is rendered in a JSP by html table. the user
>can click one of the 4 column headings to sort the
>result. what is the best to achieve this ? thanks in
>advance.

Run the query and dump the results into Javascript arrays generated by the JSP. Then have the Javascript do the sorting on the client side. Don't bother the database with it.
TW

===========================================================================
To unsubscribe, send email to listserv@(protected)
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected)".