Virtual Tables

Hello everybody.

This is my first post and I am not too familiar with ASP (but can gt along as I know a bit of VB/VB .NET).

I have an asp page that contains a table. The table is populated from data in an Access database table that matches certain criteria (contained in the querystring when the page is called).

I need to be able to sort the results. I can't do this using DHTML as one of the table columns must contain hyperlinks (I don't think you can sort a table if it contains tags other than <tr> <td> <thead> and <tbody>, though I may be wrong about this).

The second column in the HTML table gets it's values from other asp code that gets the last modification date and time of the document that is hyperlinked in column1. This information is not, therefore, in the database so I can't sort my recordset by that field.

The solution that I have come up with is to have my asp code loop through each document that matches the criteria, and creates a new table in the database and populate that with the document path, name, and it's modification date.

A new recordset is then created, sorted by modification date, and is used to then populate the HTML table. The Access table is then dropped.

This smacks of inefficiency to me. Is there any way that this new table can be created "virtually" in memory and then disposed of afterwards.

Sorry for the long post, but I felt it necessary to fully explain what I am attempting.

Look forward to your help.

I cant see why you need to create this new table and then drop it.

Can you post your code as a .txt attachment to the forum and Ill have a look.

Here's the code...it's a bit messy, I'm afraid.