Re: Using recordset as table

Ennex wrote:
>> You can't. The database engine knows nothing about previous
>> resultsets that have been sent to the client.
>
> I'm doing all my jscript on the server. I believe the recordset
> object remains in the server's memory until I close it. That's why I
> felt certain that there must be some way to operate on it as a table.

Of course it is. But that does not mean that it exists in the database
engine's memory space. There are two separate processes: the asp process
(client), and the database process.

>
> I considered using a subquery, but the queries are quite complex
> and they appear multiple times in the other queries that reference
> them, so it seems horendousnly inefficient to have the engine
> recalculate the same complex subquery over and over again instead of
> referencing a stored recordset.
>
> Can it really be possoble that there is no way to do this?

Yes, sorry. I mentioned a workaround (using a work table in the database, as
well as using the recordset Filter property) in the thread you started in
..asp.db. I will cp this reply there as well. Please crosspost instead of
multiposting. It's hard to carry on a conversation in two separate rooms

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.