Dynamic to static

[T McDizzle]

Is there a way for me to take a table that is being built dynamically and have
it be stored as static information in memory somehow so that I can sort it in
anyway that I want. Due to various complications (read my other post to know
more), after many many hours and dozens of attempts at getting the table to
sort the way I want it to in the queries, I cannot. I basically want to store
the information in the dynamic table that is being built so that I can sort by
any of the columns that I would like. Any ideas would be appreciated.

[Ian Skinner]

Are you referring to a record set? If so, then you just assign the
record set to a persistent scope such as session, application or server:
session.myRecordSet for example. This does require some code to turn on
some of these sessions, but it is well documented.

Or are you referring to an actually html table being built from your
data? In this case the <cfsavecontent variable="foobar"></cfsavcontent>
will do what you want, just wrap the generated output on these tags and
it is saved to the variable given in the variable parameter.

HTH

Ian Skinner

T McDizzle wrote:

> Is there a way for me to take a table that is being built dynamically and have
> it be stored as static information in memory somehow so that I can sort it in
> anyway that I want. Due to various complications (read my other post to know
> more), after many many hours and dozens of attempts at getting the table to
> sort the way I want it to in the queries, I cannot. I basically want to store
> the information in the dynamic table that is being built so that I can sort by
> any of the columns that I would like. Any ideas would be appreciated.
>

[T McDizzle]

It is an actual HTML table being built from data, and while the <cfsavecontent>
tag would store the data , I don't think it would allow me to sort that data.
If it can, please let me know how. If not, I'll probably need more
recommendations. Thanks though.

[Ian Skinner]

Nothing is going to make a basic HTML table sortable. If you need that
you are going to be looking at things like DHTML code to include
javascript to sort the table (or AJAX to take this to the next level),
or for <cfform> datagrid type controls (or flex to take that to the next
level).

But, my first approach would probably be to store the record set data
that builds the table, sort this as needed then rebuild the HTML.

T McDizzle wrote:

> It is an actual HTML table being built from data, and while the <cfsavecontent>
> tag would store the data , I don't think it would allow me to sort that data.
> If it can, please let me know how. If not, I'll probably need more
> recommendations. Thanks though.
>

[paross1]

You could display your output in a CFGRID, then you could sort by any column at will

Phil

[JaredJBlackburn]

I've had good luck doing what Ian said - storing the query in the session
scope. Then I can use query of queries to sort the data using a simple order
by clause and without having to go back to the database on each pageload. To
rebuild the table, I loop through the reordered query.

This does assume that your data is relatively static because you're not
getting any updates from the database on your resorts.

[T McDizzle]

I have 2 main questions at this point:
1.) Is there a way to create a CFGrid with two queries and then sort the
entire table based on one query?
2.) How exactly do I go about doing this with a session or recordset, whatever
the case may be, to get it to sort properly?
The more input the better. Thanks to everyone for helping thus far.

[paross1]

Combine and sort your two queries in a Q-of-Q, then use it to drive your CFGRID.

Phil

[SSandlin]

simple problem, simple solution!

use one page to select your sort oder column selection.

use result page to set session variable for column name, the use if/else
statements to qury database by selection.

Do it all the time, works well.