Maybe this is an ASP question, but it seems more appropriate here. I want to add records to a temporary table via an active server page. Each time a new record would be added would require a reload of the page, thus a new connection. I want to have a temp table with either one # or two ##, but since more than one user would be adding line items, I'd prefer one #, and then copy those records to the permanent table and delete/destroy the temp table, when the user clicks "confirm"
My problem is, how do I keep a temp table alive while loading a new page?
Kevin
My problem is, how do I keep a temp table alive while loading a new page?
Kevin